Skip to Main Content
Forums

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!

How to force plan in 10g

taohikoJun 23 2013 — edited Jun 24 2013

Hi Expert

     I got the problem when I use dbms_stats with histogram information that improve some step of End-Of-Day process but impact some process. I checked plan of SQL before that use unique index after collected histograms that use index fast full scan.

     So I need to force good plan to that SQL but I knew only one solution that use DBMS_SPM on 11g but 10g How to?

Thank you in advance.

Hiko
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2013
Added on Jun 23 2013
3 comments
259 views