tuning SQL. PLEASE help

tuning SQL. PLEASE help

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by 'Alice ^_~***' on August 20, 2001 at 20:23:18 EST:

I have a table with 502 columns and millions of rows.
I have done an analyze to the table, and I have indexes for some of the columns. However, sometimes oracle would choose to use one of the index to query the data when it can query the data twenty times faster with a full table scan. What can I do to make oracle does the right thing? (I can't use a hint because my queries are very random)

Follow Ups:

Post a Followup

Name:
E-Mail:
Subject:
Message: : I have a table with 502 columns and millions of rows. : I have done an analyze to the table, and I have indexes for some of the columns. However, sometimes oracle would choose to use one of the index to query the data when it can query the data twenty times faster with a full table scan. What can I do to make oracle does the right thing? (I can't use a hint because my queries are very random)