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?