Answers

Question and Answer:

  Home  IBM DB2

⟩ 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 composite index will be efficient.

 242 views

More Questions for you: