Re: What are common indexes?

From: <sybrandb_at_yahoo.com>
Date: 15 Aug 2005 07:57:27 -0700
Message-ID: <1124117847.289446.206080@g44g2000cwa.googlegroups.com>

1 No.
If you know the city and the state is irrelevant, the index on (city, state) will still be of use.
If the city is irrelevant, the skip scan algorithm in 9i will still use this index.
Why do you insist on indexing everything?

2 Sort of. In most cases the state is irrelevant, as there are not that many place names occurring in more than one state. However if you create an index on (state, city) make sure you compress the first column.

Hth
Sybrand Bakker,
Senior Oracle DBA Received on Mon Aug 15 2005 - 09:57:27 CDT