?
Solved

Rebuild Indexes - How long?

Posted on 1998-02-03
3
Medium Priority
?
377 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 10

Accepted Solution

by:
bret earned 150 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

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

719 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