"Shridhar Daithankar" <shridhar_daithankar@persistent.co.in> writes:
> On 26 Sep 2002 at 11:50, Mario Weilguni wrote:
>> Just an idea, I noticed you use char(10) for esn and min, and use this as
>> index. Are these really fixed len fields all having 10 bytes?
> 10 bytes. Those are id numbers.. like phone numbers always have all the digits
> filled in..
If they are numbers, can you store them as bigints instead of char(N)?
regards, tom lane