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 |
|
TSQLMan
Posting Yak Master
160 Posts |
 Posted - 2005-11-21 : 17:18:28
|
| When you create a Maintenance Plan and tell SQL Server to Optimize indexes, does it actually perform a DBCC DBREINDEX or does it just defrag the indexes? I have always set up a sproc, and set it up as a job, but I have a new DBA, who is using Maintenance Plans on some of our smaller servers. Any reason not to use Maintenance Plans?Thanks, TSQLMan |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-21 : 17:37:17
|
| It performs DBREINDEX. None of the options in the db maint. wizard perform a DEFRAG.Tara Kizeraka tduggan |
 |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Maintenance Plans