Keep SQLtest alive: Help cover this month's $100 server costs to keep all lessons and the SQL playground online. Support the project →
SQL code copied to buffer
Task 14:

Is the index fit for queries?

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

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

The check result will appear here.