index hint ignored?

2003-01-31 Thread Cunningham, Gerald
Title: Message Hi there. I have a non-unique index on a table, and I'm trying to force Oracle to usethe index - but it always does a FTS. Why? (I've tried it with and withoutthe alias) SQL set autotrace traceonlySQL SELECT /*+ INDEX(A,vehicle_veh_year_indx) */ DISTINCT veh_year 2 FROM

RE: index hint ignored?

2003-01-31 Thread Koivu, Lisa
Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message-From: Cunningham, Gerald [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 1:31 PMTo: Multiple recipients of list ORACLE-LSubject: index hint ignored? Hi

RE: index hint ignored?

2003-01-31 Thread K Gopalakrishnan
Of Cunningham, GeraldSent: Friday, January 31, 2003 10:31 AMTo: Multiple recipients of list ORACLE-LSubject: index hint ignored? Hi there. I have a non-unique index on a table, and I'm trying to force Oracle to usethe index - but it always does a FTS. Why? (I've tried

RE: index hint ignored?

2003-01-31 Thread Fink, Dan
and returns the quickest. Dan Fink -Original Message-From: Cunningham, Gerald [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 11:31 AMTo: Multiple recipients of list ORACLE-LSubject: index hint ignored? Hi there. I have a non-unique index on a table

RE: index hint ignored?

2003-01-31 Thread Cunningham, Gerald
]; Cunningham, GeraldSubject: RE: index hint ignored? Hi Jerry, Methinks it's because this is a small table. 20 records? Peanuts. Why bother with the index. On the same token you should probably not spend a lot of time worrying about this... unless this is just a learning exercise

RE: index hint ignored?

2003-01-31 Thread Koivu, Lisa
Friday. LK -Original Message-From: Cunningham, Gerald [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 2:32 PMTo: Koivu, Lisa; [EMAIL PROTECTED]Subject: RE: index hint ignored? Thanks, Lisa. This particular table is rather small (~20,000 rows, 1.3 Mb in size, 20

RE: index hint ignored?

2003-01-31 Thread Cunningham, Gerald
Title: Message I've tried it both ways, with the comma and without - same result. -Original Message-From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 2:13 PMTo: Multiple recipients of list ORACLE-LSubject: RE: index hint ignored? Hi

RE: index hint ignored?

2003-01-31 Thread Cunningham, Gerald
PMTo: Multiple recipients of list ORACLE-LSubject: RE: index hint ignored? Gerald, Is veh_year a nullable column? If so, an index lookup may give you incorrect results (nulls are not indexed), so a full table scan will be used. Of course, is a full table scan a bad choice? Don't

RE: index hint ignored?

2003-01-31 Thread Janardhana Babu Donga
Title: Message Try Analyzing the table first and issue the select stmt. -- Babu -Original Message-From: Cunningham, Gerald [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 11:56 AMTo: Multiple recipients of list ORACLE-LSubject: RE: index hint ignored? I've

RE: index hint ignored?

2003-01-31 Thread Jamadagni, Rajendra
Title: RE: index hint ignored? Hmmm ... without where clause you are retrieving all rows ... how would you enforce index? Try adding where veh_year = veh_year ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN

RE: index hint ignored?

2003-01-31 Thread Fink, Dan
recipients of list ORACLE-LSubject: RE: index hint ignored? Hi Dan, H. That's interesting. Yes, the column does allow nulls. Not sure if there actually are any null values, I'll have to check... Thanks! - Jerry -Original Message-From: Fink, Dan

RE: index hint ignored?

2003-01-31 Thread Johnson, Michael
-From: Cunningham, Gerald [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 10:31 AMTo: Multiple recipients of list ORACLE-LSubject: index hint ignored? Hi there. I have a non-unique index on a table, and I'm trying to force Oracle to usethe index - but it always

Re: index hint

2002-01-17 Thread Scott Canaan
PROTECTED]' Onderwerp:index hint Hi, I'm on Oracle 7.3.4 HP-UX 10.20 and trying to get some queries working again on same performance after an index has been added in order to get around possible deadlocks because of use of a foreign key relation. I tried adding an hint

Re: index hint

2002-01-17 Thread Stephane Faroult
Refer to aliases (in that case 'oa'), not tablenames, in hints. Jeroen van Sluisdam wrote: -Oorspronkelijk bericht- Van: Jeroen van Sluisdam Verzonden:donderdag 17 januari 2002 14:40 Aan: '[EMAIL PROTECTED]' Onderwerp:index hint Hi, I'm on Oracle 7.3.4 HP-UX

Re: index hint

2002-01-17 Thread Marin Dimitrov
change the hint to /*+ INDEX(oa I_OPTION_ALLOTMENTS_2) */ if the statement uses an alias for a table, then the hint must use the alias too hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences

Re: index hint

2002-01-17 Thread Igor Neyman
Verzonden: donderdag 17 januari 2002 14:40 Aan: '[EMAIL PROTECTED]' Onderwerp: index hint Hi, I'm on Oracle 7.3.4 HP-UX 10.20 and trying to get some queries working again on same performance after an index has been added in order to get around possible deadlocks because of use

Diff. between FIRST_ROWS and INDEX hint - is there any?

2001-02-20 Thread dana mn
Is there any difference between the FIRST_ROWS hint (which is said to "generally force the use of indexes" - Niemiec) and the use of the INDEX hint (without specifying a particular index)? Is something else going on behind the scenes with FIRST_ROWS or is this gratuitous bloat that