I have a table with 50 columns which is populated from 14 different tables.
slect part is taking 8 min. but when I insert into table explain plan is giving 9hrs.
I tried with both set and multiset tables and with and without group by. Nothing helped the load.
I tried changing PI also.
But intrestingly create table as (sel .........) with data completes in 8 min.
when I try to insert into new table ie empty table explain plan showing more time.
All the tables used in the query have collect stat on the require fields also.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.