Re: Reorder Primary Key - any problem?

>[Case1] Primary Key (field1, field2)
index for (field1, field2) or (field2, field1) or *(field1)*.

>[Case2] Primary Key (field2, field1)
index for (field1, field2) or (field2, field1) or *(field2)*.

so, If you query with condition (field1, field2) <- order doesn't matter [Case1] and [Case2] should be the same, I think.

In case query with (field1) or (field2) only, only [Case1] or [Case2] will be available. Received on Mon Sep 06 2004 - 21:34:30 CDT