Subject Re: [firebird-support] Index speeds For different field types
Author Ann W. Harrison
At 09:44 AM 9/14/2004, williamvdw2004 wrote:
>Is there a difference in speed for indexes of different field types.
>eg. select * from transactions where transno = '1234'
>Will firebrid return this record quicker when transno is numeric or
>Does the datatype make a difference?

No major difference. When building an index key, Firebird changes
all values to keys that can be compared bytewise.