SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query Cost Difference

fameDec 30 2014 — edited Dec 30 2014

Hi all,

I have two database schemas.

one is dev and another one is QA.

Both database's version : 11.2.0.3.0

If i run a explain plan for query in dev, it gives cost 231.

But, same query im using in QA, it gives cost 24642.

I have checked the indexes in both databases are same only.

Please help me out on this.

Regards,

Fame

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 27 2015

Added on Dec 30 2014

6 comments

214 views