Oracle-L: Re: AQ query from dequeuw procedure not using index -URGENT

From: Casey A. Jordan <cjordan_at_imcwv.com>
Date: Tue, 10 Dec 2002 06:59:09 -0800
Message-ID: <F001.005161ED.20021210065909@fatcity.com>

RE: AQ query from dequeuw procedure not using index -URGENTWhen a hint is in your code it will automatically use the cost based optimizer, even if you have the database or session is set to RULE. Therefore you will need stats collected. If you still have problems then look over this paper http://www.evdbt.com/SearchIntelligenceCBO.doc. It will explain some ways to help improve the explain plan selection for the cost optimizer.

Casey

Original Message ----- From: orafaq To: Multiple recipients of list ORACLE-L Sent: Monday, December 09, 2002 4:44 PM Subject: Re: AQ query from dequeuw procedure not using index -URGENT

This database is running RULE so analyzing wont help. Outlines is a good idea. Any known issues with outlines in 8173?

Thanks
Shaleen

Original Message ----- From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, December 09, 2002 12:39 PM Subject: RE: AQ query from dequeuw procedure not using index -URGENT

Outlines is the way to go as John suggested ... also ensure that all tables related to the queues are analyzed ... regularly.

Raj

Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
From: John Kanagaraj [mailto:john.kanagaraj_at_hds.com] Sent: Monday, December 09, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: AQ query from dequeuw procedure not using index -URGENT

Shaleen,

Have you considered using Outlines? John Kanagaraj

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Casey A. Jordan
INET: cjordan_at_imcwv.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Dec 10 2002 - 08:59:09 CST