Composite index question

From: <>
Date: Sun, 13 Jan 2008 12:34:56 -0800 (PST)
Message-ID: <>


  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

Original text of this message