Terence wrote:
Hi List,
When using EXPLAIN, the key length on an integer column is stated as 4.
However the column is running into 7 digits, and that's affecting our
performance. Anyway to increase the key length?
From the manual I have found that it can be done for varchar cols.
Thanks for any
Hi List,
When using EXPLAIN, the key length on an integer column is stated as 4.
However the column is running into 7 digits, and that's affecting our
performance. Anyway to increase the key length?
From the manual I have found that it can be done for varchar cols.
Thanks for any help.
--
MySQL