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
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
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
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
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
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.
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?
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