🚀 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 46:

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

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

Tutorial
The check result will appear here.