Solved

Rebuild Indexes - How long?

Posted on 1998-02-03
3
350 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

830 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