Results 1 to 3 of 3

Thread: DBREINDEX:How does it work?

  1. 06-10-2005, 05:53 PM #1
    DBFan
    DBFan is offline Registered User
    Join Date
    Aug 2004
    Location
    USA
    Posts
    80

    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?
    Reply With Quote Reply With Quote
  2. 06-10-2005, 06:34 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    It reads index tree and creates a new and balanced one. So you should have atleast the size of existing index free.
    Reply With Quote Reply With Quote
  3. 06-13-2005, 09:45 AM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Log space needed depends on how many rows involved, you should let log file auto grow.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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