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.
  • Interview Candidate
  • 1
  • 4749

Showing Answers 1 - 1 of 1 Answers

saibabu

  • Jan 11th, 2007
 

if an index is  created  on more than  one column  ,which r frequently used in where clause of  select statement.  it will show the  effect in increace in performance .

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions