Hi,
How to reduce no. of non clusterd indexes in sql server table???
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Sep 17, 2013, 4:24 AM
hi,
for example you have table and has five column, out of five, one is primary key.
Table1
Column A, B, C, D, E
Here A is primary key so cluster index create by default.
now this all four column B, C, D and E are used with where or order by clause or it is used with join. so we have to create noncluster index on these columns to improve performance of our sql query.
instead of creating 4 different noncluster index of on table you can create combine noncluster index using Include keyword
not sure whether it is useful or not.
Ravi ShekharPosted Sep 17, 2013, 1:25 AM
all 5 indexes required for 5 different queries then?
Jignesh TrivediPosted Sep 17, 2013, 1:12 AM
hi,
I think, these are indexes that really required.
but base on project requiremetn you may remove some of them.
like table 's column which rarely used in where or in join.
i think this is manually process, you have to identify index which really required....
:)Ravi ShekharPosted Sep 17, 2013, 12:32 AM
http://www.c-sharpcorner.com/Blogs/12986/how-to-get-required-index-in-sql-server-table.aspx
In this scienario there are multiple indexes which contain same columns .thats y i want to reduce no. of indexes
Jignesh TrivediPosted Sep 17, 2013, 12:16 AM
hi,
As per my knowledge, non cluster index is not create automatically.
base on table structure and table 's column used in join and where clause you have to create non cluster index on that column to speed up you SQL query.
here question is why you want to reduce no of non clustered indexed?