Re: Increase Integer Key Length

2005-05-13 Thread Michael Stassen
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

Increase Integer Key Length

2005-05-13 Thread Terence
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