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