DBA > Job Interview Questions > DB2 ( IBM Database 2 ) Interview Questions

What is a composite index and how does it differ

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a composite index and how does it differ from a multiple index ?

A multiple index is not one index but two indexes for two different columns of a table. A composite index is one index made up of combined values from two columns in a table. If two columns in a table will often be accessed together a compsite index will be efficient.

(Continued on next question...)

Other Job Interview Questions