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 |
|
nicky_river
Yak Posting Veteran
55 Posts |
 Posted - 2010-10-17 : 02:07:34
|
| Hi,how do i know for which column do i create an index ? and how do i know if a index created is a wrong index ?Thanks !!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-10-17 : 02:10:01
|
| It depends on your queries basically. See on what basis you'll be trying to retrieve data from table ie WHERE condition in queries, the columns being retrieved and also selectivity of data in column etc.what do you mean by wrong index? It really depends on what type of query you write on table------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
nicky_river
Yak Posting Veteran
55 Posts |
Posted - 2010-10-17 : 02:13:40
|
| By wrong index i meant was that, How will I know whether the index i have created for a column is the right index ? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-10-17 : 05:03:13
|
| Run the query, check the execution plan, see if the query is using the index in an optimal way. If it's not, that was the wrong index.This series (3 parts) may be of interest: http://www.sqlservercentral.com/articles/Indexing/68439/--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Regarding Indexes