Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    109

    Unanswered: Optimizing table in mssql

    Hi there,
    Is there an optimize table command in mssql which will work the same way as "OPTIMIZE TABLE tablename" of mysql?

    I have a php application that should work on both mysql and mssql. To do defragmentation, I am using the above command. Is there an equivalent in mssql?

    Cheers,
    Celia

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I presume optimise table defragments the table and indexes? If not - please post what it means.

    To defrag an index check out the following in BoL:
    2000
    - DBCC DBREINDEX
    - DBCC INDEXDEFRAG
    2005
    - ALTER INDEX ... REORGANISE\ REBUILD

    You will need to see which options are best for your environment.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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