SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
db Index Analyzer

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
db Index Analyzer
Author Message
Ed Dailey



Joined: 16 Jan 2000
Posts: 1

Post db Index Analyzer Reply with quote

I have begun to review your product and find it to be great. I have one concern with the index analyzer. I still receive a message about high clustering and to rebuild the index. After I rebuild the index, I still receive the message. Any ideas? Thanks.

Wed Mar 01, 2000 1:42 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: db Index Analyzer Reply with quote

The index clustering factor is a measurement of the amount of (dis)order of the table this index is for. Therefore, to improve the performance you need to "re-built" the table then reindex it. To do this, use CREATE TABLE ... AS SELECT ...
then built the index.

: I have begun to review your product and find it to be great. I have one
: concern with the index analyzer. I still receive a message about high
: clustering and to rebuild the index. After I rebuild the index, I still
: receive the message. Any ideas? Thanks.

Thu Mar 02, 2000 9:39 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.