Re: O9i: How to create a matching index to a given query

From: <sybrandb_at_hccnet.nl>
Date: Mon, 02 Apr 2007 23:35:50 +0200
Message-ID: <nnt213tdbh0upk6v9bq07mr62lnfh61hkg@4ax.com>

On Mon, 02 Apr 2007 18:36:38 +0200, Andreas Mosmann <mosmann_at_expires-30-04-2007.news-group.org> wrote:

>Now I know that the table is called drive table and it is useless (or
>bad) to take a lookup table as a drive table. I also know that it is
>only important to Oracle to find all columns first, that minimize the
>number of rows. Does this mean that an index with only these columns is
>better than that one that includes the IDs for lookup tables?

Generally speaking one should index primary keys separately and foreign keys separately. A composite index like you outlined will provide impredictable results.

Hth

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Mon Apr 02 2007 - 16:35:50 CDT