September 24, 2006 at 6:24 pm
i am trying to tune my db performance. i guessing its to do with indexing. i tried indexing through the db maintenance plan but that fails for some reason. So i am trying to re-index table by table.
I ran the DBCC SHOWCONTIG command and found some scan density less than 50%
I then took the table names and executed the command ->
DBCC DBREINDEX(TableName,' ')
i checked with the DBCC SHOWCONTIG but the values are still the same. nothing happened, Right??? should i have done something else.
September 25, 2006 at 3:36 am
Can you tell us what indexes you already have on the table please? clustered, non-clustered, that will give us a little bit more info to go on.
September 26, 2006 at 7:02 am
Someone correct me if I am wrong. If the table(s) in question do not have a clustered index then rebuilding the indexes on that table will not defrag the index.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply