[Firebird-devel] Like and index

[Philippe M. <mak...@fi...>]

SELECT myfield LIKE 'A%' -> use index
SELECT myfield STARTING WITH 'A' -> use index

SELECT myfield STARTING WITH 'A' OR myfield STARTING WITH 'B' -> use index
SELECT myfield LIKE 'A%' OR myfield LIKE 'B%' -> does not use index

I thought that for the optimizer, LIKE 'A%' is equivalent to STARTING
WITH 'A', it seems that is not true when there is an OR


-- 
Philippe Makowski