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

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6642

Re: db Index Analyzer

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.