Toad World® Forums

Concatenated Indexes and Index column order


#1

A concatenated index, also known as multi-column, composite or combined index, is one index across multiple columns. In case of queries with multiple equality conditions, even though multiple single column indexes can result in very good performance, a single concatenated index solution is preferable as it


This is a companion discussion topic for the original entry at https://blog.toadworld.com/concatenated-indexes-and-index-column-order