Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> outlines don;t work
Dear All,
Have the following problem:
Config info: Sun Solaris 5.8 , oracle 8.1.7.4 32 bit
I need to create outlines for a sql statement inside a PL/SQL due to the reason that one of the tables used by this query was recently partitioned and the performance degraded.
So what I do is:
Have created a replica non partition table, set stored outlines , run pl/sql and got the before explain plam. I do the same with the partition table. I then exchange the hints and hintcount between the two and try to use the outline ( this procedure is detailed on a document compiled by Jonathan Lewis http://www.dbazine.com/jlewis4.html) .
Although I alter the session to use the correct category the outline is not used.
Has anybody tried this before? Any hints!
Kind Regards,
Hatzistavrou Yannis
![]() |
![]() |