Post reply

Table defragmentation in SQL 2000

  • January 9, 2008 at 9:24 pm

    #119533

    Hi All,

    I am preparing for database defragmentation. As I run through BOL and lots of online docs, all talks about DBREINDEX and INDEXDEFRAG utility. I understand, with these utilitis the defragmentation can be done only at indices level. How do i carry the defrag for the base tables? Is there any other method/tool/utility available on SQL 2000.

    Appreciated any help.

    Thanks n advance,

    Rgds

  • January 9, 2008 at 10:01 pm

    #766469

    As far as I know only DBCC INDEXDEFRAG utility is available for defrag of Indexes which is used for both cluster & non-cluster indexes in SQL Server 2000.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • January 9, 2008 at 10:01 pm

    #766470

    If its in SQL 2000 pls post in the appropriate forum.

    By base tables do u mean heaps (tables without indexes).

    "Keep Trying"

  • January 9, 2008 at 10:26 pm

    #766476

    Thanks for your infor.

    I mean 'Base tables' as database tables (normal tables).

    Rgds,

    Mahen

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply