RSS Feed for This PostCurrent Article

Oracle: Order of Index Fields

Here are some general guidelines for the order of index fields in Oracle.

The order of columns in the CREATE INDEX statement can affect query performance. In general, specify the most frequently used columns first.

If you create a single index across columns to speed up queries that access, for example, col1, col2, and col3; then queries that access just col1, or that access just col1 and col2, are also speeded up. But a query that accessed just col2, just col3, or just col2 and col3 does not use the index.

There are guidelines for

All the guidelines are available from Managing Indexes

Trackback URL

Sorry, comments for this entry are closed at this time.