Skip to main content
Tweeted twitter.com/StackDBAs/status/1016651911943114752
edited body
Source Link
SQL_NoExpert
  • 1.1k
  • 1
  • 20
  • 37

Recently I have rebuild indexes uisng Ola Hallengreen script which were 99% fragmented. After rebuilt i have noticed the physical reads haver educedhave reduced a lot. Does this has anything to do with Index Rebuilt ?

Recently I have rebuild indexes uisng Ola Hallengreen script which were 99% fragmented. After rebuilt i have noticed the physical reads haver educed a lot. Does this has anything to do with Index Rebuilt ?

Recently I have rebuild indexes uisng Ola Hallengreen script which were 99% fragmented. After rebuilt i have noticed the physical reads have reduced a lot. Does this has anything to do with Index Rebuilt ?

Source Link
SQL_NoExpert
  • 1.1k
  • 1
  • 20
  • 37

Does Index Rebuild Reduces physical read from disk

Recently I have rebuild indexes uisng Ola Hallengreen script which were 99% fragmented. After rebuilt i have noticed the physical reads haver educed a lot. Does this has anything to do with Index Rebuilt ?