🙏 Thank you for your support. Last month we received only $32. That covers servers, but not development, so there will be no new lessons or features this month. If you can, please support next month. Support now →
SQL code copied to buffer
RU PT FR
Task 197:

Create functional index

For analytical purposes, we frequently query the rental table with conditions similar to DATE_FORMAT(return_date, '%Y-%m') = 'YYYY-MM' (where 'YYYY-MM' represents a specific year and month). To significantly improve the performance of these queries, create a functional index named idx_return_date_func on the return_date column, utilizing the DATE_FORMAT function.

Use MySQL syntax to write your answer. Descriptions of tables are provided in the right pane.

Write your request in the field below and click the "Check it!" button.
Get hint
Copy code Clear editor

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

Privacy & Cookie Policy.