Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    THAILAND
    Posts
    15

    Unanswered: Reorganize table

    Hi there .

    1. Is there any way to reorganize table ?
    2. How difference between truncate table and delete * from AAA

    Regards.
    1

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    TO re-org DBCC DBREINDEX is best method to go.

    The TRUNCATE TABLE statement is a fast, nonlogged method of deleting all rows in a table. It is almost always faster than a DELETE statement with no conditions because DELETE logs each row deletion, and TRUNCATE TABLE logs only the deallocation of whole data pages. TRUNCATE TABLE immediately frees all the space occupied by that table's data and indexes. The distribution pages for all indexes are also freed.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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