Re: indexes

Hi

I don't think the issue is whether A is a FK but the desirability of the index to the execution plan.

If you had a PK of ABC it is a unique index with A at its highest level therefore if you separately indexed A it would be no more direct than the A layer of the ABC index.

hope it helps

Rod

-- 
Rod Corderey

Lane Associates
RodCorderey_at_Lane-Associates.com
http://www.Lane-Associates.com




> Webber Valerie H wrote:

> 

> Is it safe to say that Oracle will use the composite index on A,B,C if A

> is a foreign key. What I'm getting at is that I don't need a separate

> index on column A which is a foreign key if I already have the composite

> index A,B,C

> 

> Thanks for all the help!