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.
|