Composite index question

Hi,

  I have a question on how composite index should be used. As an example, my queries often select two leading columns, column_1 and column_2 of a table. Should I create a composite index using column_1 and column_2, or should I create two separated indexes for column_1 and column_2? What are the differences between these two approaches and performance implications?

  Thanks in advance.

  Nick Received on Sun Jan 13 2008 - 14:34:56 CST