create table statement runing for more than 2 days
Hi All,
On a datawarehouse instance a user is working on a project and that requires to have information from two table that is not existing on another table
Example:
-------------
they have TABLE_A (partitioned with 2 million records) and TABLE_B (has 27 lacs of records) what they are trying to do is like
create TABLE_C partition by hash (colxx) partitions 4 parallel (degree 4) as select * from TABLE_A where colXX not in (select colXX from table TABLE_B);
and when i shooted this create command its running for more than a day
TABLE A is a partitioned table and it has around 2 million rows
On a datawarehouse instance a user is working on a project and that requires to have information from two table that is not existing on another table
Example:
-------------
they have TABLE_A (partitioned with 2 million records) and TABLE_B (has 27 lacs of records) what they are trying to do is like
create TABLE_C partition by hash (colxx) partitions 4 parallel (degree 4) as select * from TABLE_A where colXX not in (select colXX from table TABLE_B);
and when i shooted this create command its running for more than a day
TABLE A is a partitioned table and it has around 2 million rows
0