Non clustered primary key on MySQL
Hi:
We have an application in our company and we use 32 byte keys,
generated from hibernate, being used as primary keys in our MySQL
database. As these are the primary keys for MySQL, they also become
the clustered index for the table for which they belong to. I don't
have any other field that I would like to use as clustered key, and I
don't want to create an auto increment field just for that.
In resume: is there anyway to DISABLE MySQL from creating a clustered
index and to make it order the records in the same order as they're
inserted in the database? I know SQL Server does that and I was hoping
MySQL would do the same.
Regards, Ravi.
|