I have large tables having more than 600000 to 1000000 rows.
We have a select query....
In where clause we are using columns which have very few
distinct values .
I mean to say from 600000 rows ,only 15 or 20 rows have distinct values.
Performance is a issue.
What is the best way to improve performance.

oracle version is 8i.
Any help will be appreciated.

Thanks.

Sanjay