Toad World® Forums

Concatenated Indexes and Index column order


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