Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OUTLINES
On Sun, 16 Jul 2006 08:07:51 +0100, Jonathan Lewis wrote:
> If you take the query 'select * from t1 where n1 = 1' and do:
> create stored outline for .....
> then the text stored and used for matching will be exactly the text
> you supplied.. But when you run the query with cursor sharing
> enabled, the actual run-time text optimised will be more like:
> select * from t1 where n1 = ":SYS_B0"
> and that won't match the text stored.
Well, it doesn't make them very useful in these situations. That can be summarized by saying that outlines do work with cursor sharing, but not in any meaningful way. Oh, well.
-- http://www.mgogala.comReceived on Sun Jul 16 2006 - 15:48:27 CDT