If you have to create that many keys, you may want to consider changing
your data structure. You additions and updates to the database would
get pretty slow if that many indexes have to be updated.
What I usually do is change my columns to rows and add an additional
"qualifier" column to indicat
The documentation states that MyISAM tables can be used with more than 32
keys, but I can't get mysql to accept more than 32.
Also, is it possible (advisable) to build a version of the MyISAM tables
that exceed the 64 key limit? If so, how is this done?
Tom Sundquist
Circus Software, LLC
Minneapo