Skip to content

Who decides what an index is for?

A query that lists a student's marks has become slow as the table grew. An index would fix it, but it costs disk and slows every insert.

Whose job is that decision, in the roles a DBMS course defines?