238 reputation
38
bio website
location
age
visits member for 2 years, 10 months
seen Feb 18 at 7:40

Feb
9
comment Indexing a database
What I meant was, If I have separate indexes on School and ClssYear, would they be useful when searching for all people who went to Duke from classes between 1980 and 1984?
Feb
9
awarded  Scholar
Feb
9
accepted Indexing a database
Feb
9
comment Indexing a database
But would in your example two indexes: one on School and the other one on ClassYear be useful in any of the cases?
Feb
9
comment Indexing a database
While reading your answer, another question popped into my mind: Are Primary Keys usually automatically indexed, or do I have to specify myself that they will be indexed? Say, for example, in a MySQL database?
Feb
9
comment Indexing a database
I understand... Thank you!
Feb
9
awarded  Student
Feb
9
comment Indexing a database
It is a purely theoretical question("what if/why not").
Feb
9
asked Indexing a database
Feb
9
awarded  Supporter