Re: [Hibernate-devel] Question:

[Gavin_King/Cirrus%<CI...@ci...>]

>as for ms sqlserver, a multi-column index is a candidate if the first
column
>of the index is used in the where clause.  is the key column the first
>column in the index?

Cool, thanks Brad. I just asked an Oracle guy here and he told me the same
thing. So it sounds like this is pretty much the usual thing.

I will swap the order of the key + index columns in the PK constraint and
then get rid of the extra index.