RE: index hint ignored?

2003-01-31 Thread Johnson, Michael
Message-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 use the index - b

RE: index hint ignored?

2003-01-31 Thread Fink, Dan
tiple 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-

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

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&#x

RE: index hint ignored?

2003-01-31 Thread Cunningham, Gerald
2003 2:31 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

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?

RE: index hint ignored?

2003-01-31 Thread Koivu, Lisa
a braindead 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

RE: index hint ignored?

2003-01-31 Thread Cunningham, Gerald
ECTED]; 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

RE: index hint ignored?

2003-01-31 Thread Fink, Dan
s the fewest I/Os 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

RE: index hint ignored?

2003-01-31 Thread K Gopalakrishnan
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 use the index - but it always does a FTS. Why? (I've tried i

RE: index hint ignored?

2003-01-31 Thread Koivu, Lisa
iaper 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 ig

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 use the index - but it always does a FTS. Why? (I've tried it with and without the alias)     SQL> set autotrace traceonlySQL> SELECT /*+ INDEX(A,vehicle_veh_year_indx) */ DISTINCT veh_year