On 9/11/11 2:17 PM, firebirdsql wrote: > If I a tables primary key is (username, title, start_date)...I'm guessing it > will create an index on (username, title, start_date). > > If I'm querying by username, start_date, will it still use the index OR do I > need to add an extra index for username, start_date)?
Don't know the answer but one way to avoid the question altogether is to change the primary key to (username, start_date, title). BTW, what's your name?
