🚀 November has started! SQLtest.online stays free thanks to donations from people like you. Help us reach this month's goal early so the site keeps running without interruptions. Support now →
SQL code copied to buffer
Task 47:

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.