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 |
|
john.burns
Posting Yak Master
100 Posts |
 Posted - 2011-01-25 : 11:35:50
|
| My env. does not always have enough disk to allow for index rebuilds.Is there any cumulative negative effect of just getting by with reorg of indexes. I know I've read that rebuild is better for >30% frag. Of course with limited disk there is no choice.thanks for replyJB |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
john.burns
Posting Yak Master
100 Posts |
Posted - 2011-01-25 : 15:02:07
|
| I would think it is safe to say that frag. has negative effect on performance (higher reads etc..)Mine is DW env. and massive inserts/deletes produces a lot of frag.thanks for your input |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
john.burns
Posting Yak Master
100 Posts |
Posted - 2011-01-25 : 15:40:31
|
| ok thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Index Rebuilds