Computer scienceFundamentalsSQL and DatabasesBasics SQLData 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