At 08:27 AM 10/1/2002 +0200, Marcin Bury wrote:

>...
>guess what index will be taken by optimizer - the second one - optimizer
>forgot about the primary key.
>I had to switch columns in indexes to make optimizer think better.

OK, but that's a bug in the optimizer, not a characteristic
of indexes.


Regards,

Ann
www.ibphoenix.com
We have answers.