SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 two non-cluster indexes on same coulumn
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sunnyh
Starting Member

3 Posts

Posted - 02/05/2014 :  07:38:44  Show Profile  Reply with Quote
Hi,
We have two non cluster indexes on the same column for a table. Could anyone please let me know will it impact negatively on table like performance etc. ?

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1641 Posts

Posted - 02/05/2014 :  19:38:33  Show Profile  Reply with Quote
Are the indexes identical? Are the two indexes only on that one column or are other columns part of each index? Are there include columns used in the indexes?

===============================================================================
There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber (1894-1961)
Go to Top of Page

Lamprey
Flowing Fount of Yak Knowledge

4600 Posts

Posted - 02/05/2014 :  20:00:32  Show Profile  Reply with Quote
quote:
Originally posted by sunnyh

Hi,
We have two non cluster indexes on the same column for a table. Could anyone please let me know will it impact negatively on table like performance etc. ?


Yes it will have a negative impact on performance.
Go to Top of Page

sunnyh
Starting Member

3 Posts

Posted - 02/06/2014 :  00:39:04  Show Profile  Reply with Quote
Hi Bustaz Kool,

Yes they both are identical and both indexes are only on that single column.

Hi Lamprey,

Thanks for your response.
Go to Top of Page

Avinaash.S786
Starting Member

9 Posts

Posted - 02/06/2014 :  00:45:05  Show Profile  Reply with Quote
Yes. It is better not to use more than one non cluster indexes on the same column, unless until it is most needed.
Refer to the following links
http://www.confio.com/logicalread/duplicate-indexes-and-sql-server-performance/
http://stackoverflow.com/questions/6943199/sql-server-multiple-index-for-the-same-columns-performance
http://social.msdn.microsoft.com/forums/sqlserver/en-US/e6ee8c63-ea57-4c30-b950-cc7194374a89/unique-clustered-and-non-clustered-indexes-on-same-column

Avinaash S
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000