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 |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2008-10-07 : 07:02:15
|
| Looking at about 32 tables which are growing each day, slowing down and having crashes more regularly, I've been asked to create indexes. All tables have clustered indexes. So I'd need to to use non-clustered indexes?What logic do I use to choose which column to set up the indexes on? How many? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-07 : 07:07:26
|
| it depends on how you will using the columns of tables in query. select those columns which are used mostly for searching the values in table in queries for creating indexes. |
 |
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2008-10-07 : 08:24:14
|
| Remind me what the command is for updating / refreshing the indexes? |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2008-10-07 : 08:26:40
|
| It's UPDATE STATISTICS!!! That's what it needs!! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-07 : 09:49:37
|
| Best way is to look execution plan and figure out what index you need. Also you have to understand about balance-trading in SQL server about usage of index (which might be important to one but not to others). |
|
|
|
|
|
|
Create or Remove Indexes