Re: PK Index V Additional Column INdex

Thiko! wrote:
> Hi
>
> Having put some SQL through an EXPLAIN PLAN I can see that it is
doing
> an INDEX RANGE SCAN using it's Primary Key index. This if fine.
>
> However, I tested creating an index on the column in the WHERE clause
> and re running the query through the EXPLAIN PLAN. It showed the
> explain plan to be the same but just using the new index.
>
> Would there be an advantage to having the new index created or is
using
> the PK index in the exexution plan fine?
>
> This table has around 34000 rows in it.
>
> Many thanks for any advice!
>
> Thiko!

You do not provide the table structure, the query nor the query plans so how is one to make a determination? You state the PK is being used in the query prior to you creating your additional index; why is this not sufficient for your purposes?

Please provide the table structure( if possible) the original query, the create index statement and both query plans. Possibly then someone can shed a bit more light in your dark corner.

David Fitzjarrell Received on Mon May 23 2005 - 10:56:48 CDT