In Firebird 1.5 is there any difference in speed between these 3 queries if
there in an index on field1, which is a fixed size (5) text field and if the
produced number of records will be the same:

select field1 from table1 where field1 = 'abcde'

select field1 from table1 where field1 like 'abcd%'

select field1 from table1 where field1 starting with 'abcd'

It looks not, but just want to make sure.


RBS