We have a table with used cars. We often need to search by MAKE, MODEL, and YEAR_OF_PRODUCTION. We also need to search by YEAR_OF_PRODUCTION only. We do not need to search by MAKE or MODEL only. What multicolumn index would you create to fit these requirements?
Write a list of index columns separated by commas.
Composite indexes
Order of columns
Report a typo
Enter a short text
___
By continuing, you agree to the JetBrains Academy Terms of Service as well as Hyperskill Terms of Service and Privacy Policy.
Create a free account to access the full topic
By continuing, you agree to the JetBrains Academy Terms of Service as well as Hyperskill Terms of Service and Privacy Policy.