Answer
A composite index includes multiple columns, used when queries filter or sort using those column combinations.
The order of columns is important because SQL Server can only efficiently use leading key columns.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ