The Cost Based Optimizer drives me crazy...

Help me to explain this:

We have a 7.3 database running on NT.

This statement (an example) makes use of the index on column1:

        Select * from table A where column1='xxxx'

This statement does NOT make use of the index on column1:

        Insert into table B (select * from table A where column1='xxxx')

Why would this happen?

Esmé Venter
esmev_at_medscheme.co.za Received on Mon Sep 08 1997 - 00:00:00 CDT