Saved by Franco Passeggi
Who has to add the right indexes to an SQL database?
Many developers have years of SQL experience yet they know very little about the processing that happens in the database.
Markus Winand • Who has to add the right indexes to an SQL database?
It turns out that the only thing developers need to learn is how to index. Database indexing is, in fact, a development task. That is because the most important information for proper indexing is not the storage system configuration or the hardware setup. The most important information for indexing is how the application queries the data.
Markus Winand • Who has to add the right indexes to an SQL database?
as developers, we know how the app is accesing the data → the access path