Simple Question: Fragmentation on data & indexes

Simple Question: Fragmentation on data & indexes

Post by Chai Wuttivorrvattan » Thu, 14 Jun 2001 01:03:42



Hello:
    I found out that there is a lot of fragmentation on tables & indexes in
a database on the current SQL2000 server.
    BOL recommends to drop/recreate cluster indexes.
    It doesn't say anything about non-cluster indexes.  Do I have to worry
about them?  Do I only defrag cluster indexes, not non-cluster?
    Thank you.

                                                    Chai

 
 
 

Simple Question: Fragmentation on data & indexes

Post by Corey Trace » Thu, 14 Jun 2001 02:05:12


when you issue a dbcc dbreindex against the table, all
clustered/non-clustered indexes will be rebuilt.

see dbcc dbreindex for more info

corey


Hello:
    I found out that there is a lot of fragmentation on tables & indexes in
a database on the current SQL2000 server.
    BOL recommends to drop/recreate cluster indexes.
    It doesn't say anything about non-cluster indexes.  Do I have to worry
about them?  Do I only defrag cluster indexes, not non-cluster?
    Thank you.

                                                    Chai

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==  Over 80,000 Newsgroups - 16 Different Servers! =-----