I have a windows server with “wamp” and a mysql database that has a table with many columns, and I want to add index to all the columns:
Using sql, for example:
ALTER TABLE ticks ADD INDEX v65_index (v65);
ALTER TABLE ticks ADD INDEX v66_index (v66);
ALTER TABLE ticks ADD INDEX v67_index (v67);
But I get the following error:
#1069 - Too many keys specified; max 64 keys allowed
You must solve this problem
22 pekerja bebas membida secara purata $52 untuk pekerjaan ini
This is an easy fix, but you should really consider if having a table with that many columns is necessary. If you just want a fix, it will take me a few minutes to do this if I have access to the server.
I seem some limitation, my opinion to check alternative solution it seem the database is too much normalized, try to normalized as alternative solution , I am ready to discuss further.