Subject | Question regarding index |
---|---|
Author | firebirdsql |
Post date | 2011-09-11T18:17:49Z |
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)?
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)?