By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,002 Members | 2,137 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,002 IT Pros & Developers. It's quick & easy.

Multi-column Index vs Single Column Indexes

P: n/a
Hi,

Would like to know the performance differenece between Multi-column
Index vs Single Column Indexes. Let's say I have a table with col1,
col2, col3 along with a primary key column and non-indexed columns.
In queries, I will use col1, col2, and col3 together and some times
just one or two of these three columns. My questions is, should I
create one index contains col1, col2, and col3, or create 3 seperated
columns. I.e. each column has its own index. Any performance
difference?

Thanks a lot.

Aug 7 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Aug 7, 1:10 pm, Sonny <Sonny...@gmail.comwrote:
Hi,

Would like to know the performance differenece between Multi-column
Index vs Single Column Indexes. Let's say I have a table with col1,
col2, col3 along with a primary key column and non-indexed columns.
In queries, I will use col1, col2, and col3 together and some times
just one or two of these three columns. My questions is, should I
create one index contains col1, col2, and col3, or create 3 seperated
columns. I.e. each column has its own index. Any performance
difference?

Thanks a lot.
It depends on your workload. You need to try it out using the mix of
reads and writes similar to your actual activity.

Alex Kuznetsov, SQL Server MVP
http://sqlserver-tips.blogspot.com/

Aug 14 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.