Hi all,
I am using SQL server 2000. In this i have large table with index. In this i have inserted millions of record per day. So i want to defragment the index by the command "DBCC INDEXDEFRAG". What value should i note whether this table shold be fragmented or not?
I am using SQL server 2000. In this i have large table with index. In this i have inserted millions of record per day. So i want to defragment the index by the command "DBCC INDEXDEFRAG". What value should i note whether this table shold be fragmented or not?