What is another word for nonclustered index?
Pronunciation: [nˌɒnklˈʌstəd ˈɪndɛks] (IPA) 
A nonclustered index is a type of database index that helps in optimizing the retrieval of data from a database table. Synonyms for nonclustered index include secondary index, non-primary index, or secondary key. It provides an alternate path to access data that is not stored in a specific order. Other synonyms are non-clustered columnstore index, non-clustered hash index, and non-clustered filtered index. A nonclustered index is particularly useful in large, highly transactional databases where queries must be returned quickly, and data updates occur frequently. Ultimately, by using nonclustered indexes, a database query can be executed more efficiently, resulting in faster performance and better user experience.
