RE: Keep CBO plan stable(plan stability)

Hi

>As for the plan stability, while running CBO, ifI do have statistics,
>Is there any other case, that CBO is still able to change the plan?
>Can you give me a test case?

Different literals or bind variables (remember, in 9.2 Oracle peeks the bind variables value) may lead to different cardinalities and therefore to different plans.

HTH
Chris

New Features Oracle Database 10g Release 2 seminars @ www.trivadis.com

Italiano: Lugano (24-Nov)
Français: Genève (17-Nov)
Deutsch: München (20-Oct), Basel (25-Oct), Frankfurt (27-Oct), 
         Düsseldorf (23-Nov), Zürich (29-Nov), Stuttgart (13-Dec)

--
http://www.freelists.org/webpage/oracle-l