|
[Firebird-test] Like and index
From: Philippe Makowski <makowski@a6...> - 2006-05-09 07:53
|
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 |
| Thread | Author | Date |
|---|---|---|
| [Firebird-test] Like and index | Philippe Makowski <makowski@a6...> |