SQL code copied to buffer

Task 13:

Is the index fit for query?

Is the following index a good fit for the query? 
| CREATE INDEX tbl_idx ON tbl (date_column);

| SELECT COUNT(*)
| FROM tbl
| WHERE EXTRACT(YEAR FROM date_column) = 2024;
Source: The 3-Minute SQL Indexing Quiz

Good fit: No need to change anything.

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

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.