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

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