Who Has to Add the Right Indexes to an Sql Database?
The SQL language is perhaps the most successful fourth-generation programming language (4GL). Its main benefit is the capability to separate “what” and “how”. An SQL statement is a straight description of what is needed without instructions as to how to get it done.
It turns out that the only thing developers need to learn is how to index. Database indexing is, in fact, a development task.
The most important information for indexing is how the application queries the data. This knowledge—about the access path—is not very accessible to database administrators (DBAs) or external consultants.