A correctly configured index can make the SQL query fast. An index is a data structure in the database that created by CREATE INDEX statement.

The theory is that finding from an ordered dataset is faster than from unordered. SQI index is some ordered rows.


The data structures for …