Solved

Rebuild Indexes - How long?

Posted on 1998-02-03
3
332 Views
Last Modified: 2012-08-13
How long would it take to rebuild 1) a clustered index and
2) a non-clustered index  on a million record table?
Can this be run with users accessing the database?
This system has two processors and 256 MB ram.
0
Comment
Question by:vd
3 Comments
 
LVL 10

Accepted Solution

by:
bret earned 50 total points
ID: 1090133
I believe that MS SQL Server has the same sp_estspace
stored procedure that Sybase SQL Server has.  This provides
an estimate of both space and time requirements for
building indexes.

In general, it will depend a lot on the width of the table,
the width of the index, and the speed of your disks.

Create index can be run with users on the system, but they
will be locked out of the table until the create index completes.

0
 

Author Comment

by:vd
ID: 1090134
Thanks Bret. There is no sp_estspace provided with MS SQL SERVER but I understand there is a MS version available somewhere.
0
 
LVL 2

Expert Comment

by:integer
ID: 8529022
Estimating time to rebuild indexes depends on manny variables.  If you are looking for some automatic scripts to dynamically rebuild indexes, update statistics and manage space you can check out http://www.integer.org/cjm/systems/ .
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now