Re: Primary key performance int vs. char

[Mike Connell]

On a similiar note...

If a field is declared as int(11), and there is a single key index on this field,
will it be a waste of valuable space in the index if the key only has values
from 1-32?

I know I should have made the field declaration smaller to begin with.
Just wondering if this is biting me because my index might be taking up
more space than it otherwise might need to?

Thanks