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 |
|
ismaelhaider
Starting Member
2 Posts |
 Posted - 2008-11-05 : 05:17:35
|
| I have joined new Software house, so they are already run a project but the performance is very slow, When we move from one to another it takes alot time and many more.I check the database but there no index on tables except Primary key, which has default clustered index. now I want to create Index on those tables, so how I know on which column I have create index or not .kindly help me |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-11-05 : 07:43:49
|
| Read on indexes. Single out the columns which are used in joins. Index tuning wizard tool should give you an idea as well. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-05 : 09:04:15
|
| Best way is to see Execution plan and determine what are the indexes you exactly need. You can't fully rely on Database tuning advisor for index. Remember it might be good for 1 query but not for others. There should be balance trading between what is frequently used and oftenly used. |
|
|
|
|
|
|
Creating Indexs