Using outline

[omegamark]

Hello all,
will there be any increase in performance of queries if i set the use_stored_outlines parameter to true,

what is th emain of setting thi sparameter to true...
some one has aske dme to set this to true to see an increase in performanc eof queries....
but my query still takes the same tim ebefore and after..

plz tell me about outline and its uses...

thanks,

[sambavan]

Refer: Stored outline.

Sam

[pando]

outline is used for plan stability not to improve perfomance, obviously if you supply a better plan than optimizer you could improve perfomance

[omegamark]

how do i supply an explain plan

[omegamark]

how do i supply an explain plan

[sambavan]

Did you read the document?

Sam