(Select max(a job_sid) as job_sid,max(c channelise_id) as channelise_id,max(b id_id) as id_id,a id_code sum(rewrite(a. SEAS_id_FLAG_N1,'N' a wgt_n1 a. WGT_N1)) WGT_N1 sum(rewrite(a. SEAS_id_FLAG_N2,'N' a wgt_n2 a. WGT_N2)) WGT_N2 from ixrev_id_data a id b. (Select job_sid,tree_id substr(ppi_id_code,1,6) as sub_tree_id from ixrev_id_data where channelise_id in ( decide distinct tree_id from ixrev_id_data where tree_category = '42') and higher_id_sid is not null)c where a tree_id = c sub_tree_id and a. JOB_SID = c job_sid and a id_sid = b id_sid and b id_id not like '%SOP%' group by c channelise_id,a id_label) DEV ENVIRONEMNTSELECT STATEMENT ()[NULL] chop (GROUP BY)[NULL] HASH connect (RIGHT SEMI)[NULL] TABLE ACCESS (beat)IXREV_ID_DATA HASH JOIN ()[NULL] chop JOIN ()[NULL] delay find (beat)ID delay ACCESS (beat)IXREV_ID_DATA delay ACCESS (beat)IXREV_ID_DATATEST ENVIRONMENT. SELECT STATEMENT ()[NULL] chop (assort BY)[NULL] HASH JOIN (alter SEMI)[NULL] delay ACCESS (beat)IXREV_ID_DATA HASH connect ()[NULL] delay find (beat)IXREV_ID_DATA HASH JOIN ()[NULL] TABLE find (FULL)ID TABLE ACCESS (beat)IXREV_ID_DATA
The above query gives two different explain plans. In evaluate environment it is very slow. I would like to know what would furnish the different explain plan.
Possible causes:Are the same tables in both environments analyzed/not analyzed?Number of rows in each environment?
Forex Groups - Tips on Trading
Related article:
http://www.orafaq.com/forum/index.php?t=rview&goto=266395&th=89061#msg_266395
comments | Add comment | Report as Spam
|
