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