Support ongoing development - donate to help us maintain and improve the platform. 🖥️ Support sqltest →
SQL code copied to buffer
Task

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.

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

Privacy & Cookie Policy.