SQL Interview Questions #233: Is the index fit for queries?

SQL code copied to buffer

Task 233:

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

Bad fit: Changing the index or query could improve performance.

Good fit: No need to change anything.

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

Support SQLtest.online

This project has only one funding source: your donations. The monthly maintenance cost is $100.

To keep the project running next month, we need to collect at least this amount by the end of this month.

Received: $15.54 Goal: $100.00

Progress: 16%

SQL in 10 Minutes a Day by Ben Forta

Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job.

Login

Register