Composite / Concatenated SQL Indexes
When a single index has multiple columns that are indexed, it is called a composite or concatenated index. Prior to the introduction of skip-scan functionality, queries could only use the index if the leading column of the index was used in the WHERE clause. Consider the example in the following listing where the EMP table has a concatenated index on Empno, Ename, and Deptno. Note that Empno is the first part, Ename is the second…