Why is this code not working? Is it because clustered indexes is not implemented in MySQL?
CREATE INDEX niels1 ON `table` CLUSTER (attr1,attr2);
As far as I know only the InnoDB engine offers clustered indices. Also, there's no dedicated "CLUSTER" keyword; all PRIMARY KEY indices are CLUSTERed. See http://dev.mysql.com/doc/refman/5.5/en/innodb-index-types.html