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

[Casey A. Jordan]

Title: RE: AQ query from dequeuw procedure not using index -URGENT

When 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:[EMAIL PROTECTED]] 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