At 12:23 PM 02-11-01 +0000, you wrote:

>yes - that is the exact command.
>
>In fact any table I use where I would use an index is not being
>chosen. Interbase always uses Plan Natural...

Are you by any chance creating explicit indexes on your primary key columns?

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________