Allows using a composite index even when the leading column is not in the WHERE clause, by jumping between distinct values of the leading column.
Table: orders (10 million rows)
Query:
SELECT * FROM orders WHERE customer_id = 12345;
Finding the file is only half the battle. Here is a step-by-step protocol to test the quality of any databasesqlzip1 file before you attempt a restore.
Allows using a composite index even when the leading column is not in the WHERE clause, by jumping between distinct values of the leading column.
Table: orders (10 million rows)
Query:
SELECT * FROM orders WHERE customer_id = 12345;
Finding the file is only half the battle. Here is a step-by-step protocol to test the quality of any databasesqlzip1 file before you attempt a restore. index of databasesqlzip1 high quality