RE: Why are my indexes being ignored?

2001-07-02 Thread Raymond Lee Meng Hong
Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Friday, June 29, 2001 9:50 AM To: [EMAIL PROTECTED]; Carle, William T (Bill), NLCIO Subject:Re: Why are my indexes being ignored? Carle, William T (Bill), NLCIO wrote: Hi, I created an index on a table

Re: Why are my indexes being ignored?

2001-06-29 Thread Joe Raube
What is the sql statement that you are executing against this table? Carle, William T (Bill), NLCIO wrote: Hi, I created an index on a table. The table has about 83,000 rows. The index is a simple index on one field, 35 different values of the index. I analyzed the table and I analyzed the

RE: Why are my indexes being ignored?

2001-06-29 Thread Carle, William T (Bill), NLCIO
I'm returning 117 rows. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Friday, June 29, 2001 9:50 AM To: [EMAIL PROTECTED]; Carle, William T (Bill), NLCIO Subject:Re: Why are my indexes being ignored? Carle, William T (Bill

Re: Why are my indexes being ignored?

2001-06-29 Thread Thater, William
Carle, William T (Bill), NLCIO wrote: Hi, I created an index on a table. The table has about 83,000 rows. The index is a simple index on one field, 35 different values of the index. I analyzed the table and I analyzed the index, trying it both with a histogram and without a

RE: Why are my indexes being ignored?

2001-06-29 Thread Mohan, Ross
index is not selective enough. it would wind up pulling MORE db blocks in using the index than a FTS. hth - Hannibal -Original Message- Sent: Friday, June 29, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Hi, I created an index on a table. The table has about 83,000

RE: Why are my indexes being ignored?

2001-06-29 Thread Harvinder Singh
u didn't specify which type of index u have created. but for such low selectivity bitmap index might helps... -Original Message- Sent: Friday, June 29, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Hi, I created an index on a table. The table has about 83,000 rows.

RE: Why are my indexes being ignored?

2001-06-29 Thread Nicoll, Iain (Calanais)
PROTECTED] -Original Message- Sent: Friday, June 29, 2001 9:50 AM To: [EMAIL PROTECTED]; Carle, William T (Bill), NLCIO Subject:Re: Why are my indexes being ignored? Carle, William T (Bill), NLCIO wrote: Hi, I created an index on a table. The table has about 83,000

RE: Why are my indexes being ignored?

2001-06-29 Thread Carle, William T (Bill), NLCIO
:Re: Why are my indexes being ignored? What is the sql statement that you are executing against this table? Carle, William T (Bill), NLCIO wrote: Hi, I created an index on a table. The table has about 83,000 rows. The index is a simple index on one field, 35 different values