> What is the structure of you table?
> Is the data types in the table the same as in the SQL....
>
> Did you create the index after the loading the table?
> cluster the table around the most used index....
There is no point clustering a table around the most used index, unless
access to the index is non-random. eg. you are picking up more than one
consecutive entry from the index at a time. eg. Indexes on foreign keys are
excellent for clustering.
Chris