🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task 262:

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

Tutorial
The check result will appear here.