PDA

View Full Version : Clustering



Folding
08-30-2008, 08:18 PM
Hi, I have just imported all my hand histories into HM.

Should I cluster the database tables on the primary index for maximum performance? I have a bit over 20 million hands.

To be clear the SQL I am thinking of running (for each table) is:

CLUSTER tablename USING indexname;

Does HM automatically cluster one the primary key or another index?

Thanks