Results 1 to 2 of 2

Thread: Rebuild Index Script

  1. 04-03-2003, 12:31 PM #1
    jfkuser
    jfkuser is offline Registered User
    Join Date
    Oct 2002
    Posts
    16

    Rebuild Index Script

    Hi,

    Does anyone have Rebuild Index Script for entire database?

    Thanks in advance...j
    Reply With Quote Reply With Quote
  2. 04-03-2003, 01:20 PM #2
    andi_g69
    andi_g69 is offline Registered User
    Join Date
    Nov 2002
    Location
    DE
    Posts
    246
    You do not mention on which RDBMS you are working. But on SQL Server there are several possibilities to achieve that.

    1) Create a Maintenance plan which rebuilds the indexes

    2) Look up usage ob DBCC in BOL
    3) Script all tables including Indexes and derive the bits and pieces to rebuild the indexes from the script
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules