Solved

Rebuild Indexes - How long?

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
set default date format in mssql to mm/dd/yyyy 22 66
SQL Error in WHERE Clause 5 38
Permissions on Database 11 36
T-SQL: Subtracting Amounts from "Among Rows" 3 41
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…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

919 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

14 Experts available now in Live!

Get 1:1 Help Now