Friday, August 7, 2009

Connect by nocycle Query - Wrong results

The queries using “Connect by nocycle” may give different results with different versions.
Please try below workaround.

Alter the session and run the query.

alter session set "_optimizer_connect_by_cost_based"=false;
OR
alter session set optimizer_features_enable='10.2.0.1'

You can see this issue on 10.2.0.4,11.1.0.6,11.1.0.7.

Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com/

1 comment: