When should I add an index?
On columns used frequently in WHERE clauses and joins, particularly foreign keys. Indexes speed reads and slow writes, so the judgment is about access patterns. Coursework usually wants that trade-off discussed rather than indexes added everywhere.
This comes up on Database Design Coursework, where it is answered in the context of the work itself.
Not what you asked?
Ask us the actual question
Send the draft, the rubric or the score report with it. You get a real answer and a price before you commit to anything.