Composite index or single column index

Question

0.00/5 (No votes)

See more:

Hi friends,

I want to index some columns in our database. Always, I have SQL with multiple columns in my where clause.

All of those columns are already indexed individually

I am thinking to drop these single column indexes and want to create composite index for these columns i.e. creating single index with several columns rather than several indexes each with one column.

Is this approach fine??

Thanks in advance

Posted 23-Jan-14 19:45pm

MONISH K M

Updated 23-Jan-14 22:25pm

v4

Add a Solution

Comments

Ankur^\m/ 24-Jan-14 4:43am

"All of those columns are already indexed individually"
That is a very BAD design. A lot of indexes will reduce your query performance drastically. Be very wise in choosing an index. Check out execution plans of your poorly performing queries and analyze the correct indexes that are required.
About composite index, Google for "single column index vs composite column index", read the articles. It's very well discussed.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tejas Vaishnav · Answer 1 · 2014-01-23T22:36:00

Solution 1

please have a look around this...

http://grahitanusantara.blogspot.in/2011/06/single-vs-composite-indexes.html[^]
http://www.nullskull.com/q/10140481/difference-between-composite-index-and-covering-index.aspx[^]

Posted 23-Jan-14 22:36pm

Tejas Vaishnav