Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Diff betw DBCC DBReindex and reorg data and index in maint plan

Status
Not open for further replies.

mattisontara

Programmer
Jan 29, 2002
30
US
Hello. Could someone please explain to me the difference between running dbcc dbreindex and having a maintenance plan "reorganize data and index pages" under the optimizations tab in the maintenance plan wizard in sql2k?
I notice that under the maintenance plan, it has an option to "change free space percentage to x%". Is this similar to changing the fill factor when running dbcc dbreindex? Any help would be appreciated.
 
I think a reorg does a dbshrink on the database after a reindex.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top