SQL Quiz: Is the index fit for queries?

Hi! Could we please enable some services and cookies to improve your experience and our website?

Privacy & Cookie Policy.

SQL code copied to buffer

Group tasks by:

complexity

category

database

Support the project.

Buy Me a Coffee at ko-fi.com

Task 14:

Is the following index a good fit for both queries?
| CREATE INDEX tbl_idx ON tbl (a, b);

| SELECT * FROM tbl
| WHERE a = 38 AND b = 1;

| SELECT * FROM tbl
| WHERE b = 1;
Source: The 3-Minute SQL Indexing Quiz

Good fit: No need to change anything.

Bad fit: Changing the index or query could improve performance.

Mark all correct answers and click the "Check!" button

Get hint