Composite index question
Date: Sun, 13 Jan 2008 12:34:56 -0800 (PST)
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