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 |
|
pearsont74
Starting Member
27 Posts |
 Posted - 2007-03-27 : 10:31:11
|
| OK...we have a fairly large db that we have an app doing read only queries to it and I need to know what options is best for indexes on this db.Do i cluster or not? Do i create one index per a single column or 1 index for muliple columns? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-27 : 10:34:10
|
| Post some queries. That would help.Peter LarssonHelsingborg, Sweden |
 |
|
|
pearsont74
Starting Member
27 Posts |
Posted - 2007-03-27 : 11:55:33
|
| I will post them soon. I didnt write the app so i dont have them. |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-27 : 13:15:47
|
| We can help you with some specifics, but you really need to understanding indexing for yourself because it is very fundamental to making SQL Server perform well, I'd recommend the following readinghttp://msdn2.microsoft.com/en-us/library/ms175049.aspxhttp://msdn2.microsoft.com/en-us/library/ms979195.aspxInside SQL Server (Microsoft Press) |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2007-03-29 : 09:53:14
|
| I would advise reading up on indexing as this is a very tricky subject and depends on what type of queries you are running etc as what type of index is going to be the best for certain tables.You only learn by practice |
|
|
|
|
|
|
Cluster indexes vs non cluster