Computer scienceSoftware development foundationsSQL and databasesSQL basicsData Definition Language

Composite indexes

Find the truth

Report a typo

Select the right statements about the Left-Prefix Rule.

Select one or more options from the list

You need to match the order of columns on index with the order in WHERE condition.

Index can be used only from left to right.

Index can be used only from right to left.

No columns can be skipped.

Create a free account to access the full topic