Re: Reorder Primary Key - any problem?
From: Christine <karistom_at_hotmail.com>
Date: 6 Sep 2004 19:34:30 -0700
Message-ID: <693b7163.0409061834.4988717c_at_posting.google.com>
Date: 6 Sep 2004 19:34:30 -0700
Message-ID: <693b7163.0409061834.4988717c_at_posting.google.com>
>[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 Tue Sep 07 2004 - 04:34:30 CEST