Re: Stored outlines Plans Not getting used...

From: RaviAlluru <ravi.alluru_at_gmail.com>
Date: 18 Nov 2005 08:42:47 -0800
Message-ID: <1132332167.919148.45650@f14g2000cwb.googlegroups.com>

mccmx_at_hotmail.com wrote:
> > My question is how do we force all similar queries, to use the PLAN
> > from the STORED OUTLINE ?
> >
> > Am I missing something?
> >
>
> Have you analyzed the tables, stored outlines are only used when the
> underlying tables have stats gathered on them....
>
> Matt

The tables get analyzed once every week. So yes they are analyzed regularly

Any other options? Received on Fri Nov 18 2005 - 10:42:47 CST

This message: [ Message body ]
Next message: artmt_at_hotmail.com: "Re: Capturing 9iAS userid"
Previous message: Paul: "Re: SqlPlus headers"
In reply to: mccmx_at_hotmail.com: "Re: Stored outlines Plans Not getting used..."
Next in thread: dbaplusplus_at_hotmail.com: "Re: Stored outlines Plans Not getting used..."
Reply: dbaplusplus_at_hotmail.com: "Re: Stored outlines Plans Not getting used..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US