Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
andriancruz
Starting Member
38 Posts |
 Posted - 2009-05-26 : 01:56:17
|
| Hi Everyone,Need your advice/suggestion to my inquiry. It's best practice to put noncluster index to all all column in each table for query performance. Any suggestion will highly appreciated.Thanks & more power,Andrian |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-05-26 : 01:58:36
|
| No.The smaller the better.Look at the query plans to see whether an index is necessary. Include columns to avoid bookmark lookups.It can use the index for seeks up to the first column in order that isn't used in the query filter.You should try to minimise the number and size of indexes.Clustered index columns are included in clustered indexes so the smaller the clustered index the smaller all other indexes.In general a clustered index will be slower than a covering non-clustered index.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
andriancruz
Starting Member
38 Posts |
Posted - 2009-05-26 : 02:14:30
|
| Thank you for the reply. But I read some where in the web, that if you use the WHERE clause condition in stored procedures. It's better to put the noncluster index to the column that you searching. for fast result. this is true ?Thank youAndrian |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-05-26 : 02:17:58
|
| Yes as in>> it can use the index for seeks up to the first column in order that isn't used in the query filter.For best results make the index covering.The art is to decide which queries are important and need optimising.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
andriancruz
Starting Member
38 Posts |
Posted - 2009-05-26 : 02:22:08
|
| Thanks so much :) |
|
|
|
|
|
|
NonCluster Index