script to rebuild all indexes in a database?

From: David Spaisman <david.spaisman_at_compaq.com>
Date: Tue, 19 Oct 1999 12:32:12 -0400
Message-ID: <7ui6ju$i3r$1@mailint03.im.hou.compaq.com>

Hello:

I am planning to rebuild the non clustered indexes and clustered indexes for the production database.

I am using a faciliy in DBArtisan to generate a script to rebuild all nonlcustered(and non-primary indexes). This facility only generates the ddl for index which are not clustered( primary key) indexes so that I ahve to generate the table ddl to get the index name and storage parameters which I want to change and cut and paste these parameters into a create index script. Very labor-intnsive.

Doers any one have a script that will generate the ddl for the clustred indexes as well as the nonlcustered indexes with the storage parameters and tablespace assignment so that I can revise both parameters?

THanks.

David. Spaisman Received on Tue Oct 19 1999 - 11:32:12 CDT