SQL level index defrag and OS level file defrag should be orthogonal to ech
other (both help for sure). There is no clear reason why conducting one
defrag requires the other one. I will be interested in knowing if this is
not the case, r me in that case please.
But it is a good practice to regularly check and defrag the index.
--
Gang He
Software Design Engineer
Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
<cs******@dwr.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
SQL 2000
We took SQL Server offline last night and defragged the SAN. Should we
reindex or will be be okay ?
Thanks,
Craig