Hit it with the clue bat... on 2/6/04 10:25 AM, ryan.gaffuri@xxxxxxx at ryan.gaffuri@xxxxxxx wrote: > i forgot to mention, oracle is ignoring all hints in this case. Sorry about > that. anything at the database level? > > >> >> From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx> >> Date: 2004/02/06 Fri PM 12:12:21 EST >> To: <oracle-l@xxxxxxxxxxxxx> >> Subject: Re: how to get oracle to ignore an index >> >> >> Are you allowed to hint ? >> Try: >> /*+ no_index (alias, index_name) */ >> >> >> Regards >> >> Jonathan Lewis >> http://www.jlcomp.demon.co.uk >> >> The educated person is not the person >> who can answer the questions, but the >> person who can question the answers -- T. Schick Jr >> >> >> Next public appearances: >> March 2004 Hotsos Symposium - The Burden of Proof >> March 2004 Charlotte NC OUG - CBO Tutorial >> April 2004 Iceland >> >> >> One-day tutorials: >> http://www.jlcomp.demon.co.uk/tutorial.html >> >> >> Three-day seminar: >> see http://www.jlcomp.demon.co.uk/seminar.html >> ____UK___February >> ____UK___June >> >> >> The Co-operative Oracle Users' FAQ >> http://www.jlcomp.demon.co.uk/faq/ind_faq.html >> >> >> ----- Original Message ----- >> From: <ryan.gaffuri@xxxxxxx> >> To: <oracle-l@xxxxxxxxxxxxx> >> Sent: Friday, February 06, 2004 4:43 PM >> Subject: how to get oracle to ignore an index >> >> >> I have a query that uses bind variables, so it cannot use histograms. Its >> choosing the wrong index. I have been dropping the index, getting it to >> choose the correct index and using a stored outline. >> >> anyway to go: oracle ignore this index. >> >> I tried disabled, but that just returns an error, plus I have to rebuild it. >> I'd prefer to avoid building the index again. >> >> ---------------------------------------------------------------- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> ---------------------------------------------------------------- >> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx >> put 'unsubscribe' in the subject line. >> -- >> Archives are at //www.freelists.org/archives/oracle-l/ >> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html >> ----------------------------------------------------------------- >> >> >> ---------------------------------------------------------------- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> ---------------------------------------------------------------- >> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx >> put 'unsubscribe' in the subject line. >> -- >> Archives are at //www.freelists.org/archives/oracle-l/ >> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html >> ----------------------------------------------------------------- >> > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------