The main reason for a composite index is for aggregate function usage in an index.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Anytime you mix aggregates with non-aggregates you must use the group by statement
- Only one aggregate function can be nested within an aggregate function
- Only one aggregate function can be nested within an aggregate function
- Indexes can be used as subscripts while subscripts cannot be used as indexes.
- Indexes can be used as subscripts while subscripts cannot be used as indexes.
- Do not use sorted input if any of the following conditions are true
- WHERE keyword could not be used with aggregate functions.
- A function-based index is an index based on expressions