🙏 Thank you for your support last month! Thanks to you, the project keeps growing. We'd be grateful if you could support us again this month. Support again →
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

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.