DB Maintenance optimization-reorganize data and index pages

Hello,
I read in Books Online that the DB Maintenance plan optimization option
(reorganzie data and index pages) rebuilds all indexes by dropping and
recreating them. Is this the same exact operation as dbcc dbreindex? If yes,
then I am assuming our database is not going to be available during database
maintenace job, correct? In an article recommended by this newsgroup, I read
that the dbcc dbreindex is an offline operation and the underlying tables ar
e
not going to be available.
Thank you,
--
MitraMitra,
The index is not available while it is being rebuilt. In the case of a
clustered index this is the table. An online option would be DBCC
INDEXDEFRAG.
HTH
Jerry
"mitra" <mitra@.discussions.microsoft.com> wrote in message
news:704BA968-A14C-412D-B104-498623DD0BFB@.microsoft.com...
> Hello,
> I read in Books Online that the DB Maintenance plan optimization option
> (reorganzie data and index pages) rebuilds all indexes by dropping and
> recreating them. Is this the same exact operation as dbcc dbreindex? If
> yes,
> then I am assuming our database is not going to be available during
> database
> maintenace job, correct? In an article recommended by this newsgroup, I
> read
> that the dbcc dbreindex is an offline operation and the underlying tables
> are
> not going to be available.
> Thank you,
> --
> Mitra