Re: Do stored outlines work in Oracle 10.2.0.3?

On Jun 15, 7:39 am, zigzag..._at_yahoo.com wrote:
> I am using 10.2.0.3 on HP UNIX 11i. I set cursor_sharing=exact.
>
> I created a stored outline using:
> alter session set create_stored_outlines='CUSTOM';
> my sql_statement;
>
> When I run the sql statement and verify in v$sql whether outline was
> used by looking at outline_category and yes outline is used.
>
> But then I run dbms_stat on an underlying table and run my sql again,
> my plan has changed which means outline was not used. This is really
> baffling, if outline was used,
> Plan should be same as what was produced when creating outline.
> Something is
> Definitely wrong.
>
> I treied different values of cusror_sharing and none worked.

I found they do not work when cusror_sharing=force, otherwise they work. Received on Sun Jun 15 2008 - 15:53:05 CDT