January 2019
Intermediate to advanced
286 pages
7h 41m
English
In this section, we'll learn how to organize columns in indexes so that your queries are maximized.
Here's a visual representation to help you understand how to organize your columns with the WHERE, GROUP BY, and ORDER BY clauses:
In the following table, we will represent the index requirements in relation to the number of columns:

In the indexing strategy, always keep in mind that single-column indexes in complex queries are not the most efficient, but COMPOUND ...
Read now
Unlock full access