How can I check if the keys are enabled on a MyISAM table? I have a script, which populates 4 tables. It goes like this:


Disable the keys on all the tables
Populate the tables
Enabled the keys back.


The problem is that windows decided to reboot the machine at night while it was at the step 3.
I did repair on all the tables, but I have no idea whether the keys are enabled or not.

I do not want to enable it blindly, because it takes hours.

How do I check it?
Just run an EXPLAIN on a SELECT statement that would normally use a key. If the keys are disabled, then the columns possible_keys, key, key_len, ref will return null.