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 |
|
asqldeveloper
Starting Member
17 Posts |
 Posted - 2013-08-20 : 21:43:31
|
| I know that its better to have all primary, clustered, non-clustered indexes in a different filegroup than data, but what I want to know is:1. Should that be on a separate drive altogether for getting good performance?2. If the Data and index is on the same drive, is that okay and/or what are the recommendations if I cant put indexes on a different drive. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2013-08-22 : 11:15:15
|
| Some feedback:1) The Clustered index is where the data is; a Non-clustered index can put on a separate filegroup2) The performance boost would come from having the data and indexes on separate physical drive; you would need them to be in separate filegroups in order to get them on separate drives.3) How big is your data? There might not be a big boost if your data is small.4) If you can't put them on separate drives now, you might still put them in separate filegroups so that you could easily move them at a later time. I don't see a drawback from having them separated.=================================================The cure for anything is salt water -- sweat, tears, or the sea. -Isak Dinesen |
 |
|
|
|
|
|
Indexes and File Group