❤️ Thank you to everyone who supported the project! Last month you donated almost $100 — this keeps the service running free for everyone this month. I hope to count on your support for next month too. Support now →
SQL code copied to buffer
RU PT FR
Task 224:

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!" button

Get hint

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

Privacy & Cookie Policy.