Post reply

Reindexing the system tables

  • September 11, 2003 at 10:34 am

    #473758

    Wouldn't rebuilding the indexes in the sysindexes table cause an update to the table? Pointers, dropping and creating the index?


    "Keep Your Stick On the Ice" ..Red Green

  • September 11, 2003 at 11:09 am

    #473766

    Just if you are rebuilding the clustered index.

    Normally if you are rebuilding a "normal" heap index it doesn't touches the table itself.

    All the pointer infos are stored within the index.

    Otherwise you cannot rebuild the indexes on the sysindex table (this is my problem) and also I do not see any reason why I'm not allowed to do this being in single user mode.

    Bye

    Gabor



    Bye
    Gabor

Viewing 2 posts - 31 through 31 (of 31 total)

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