-
DBREINDEX:How does it work?
Can anyone shed some light as to how SQL Server performs DBCC DBREINDEX?
Does it use PRIMARY data file space and how much extra data space/log space do we need to have to be able to run this command?
-
It reads index tree and creates a new and balanced one. So you should have atleast the size of existing index free.
-
Log space needed depends on how many rows involved, you should let log file auto grow.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|