| Subject | Re: [firebird-support] SELECT UPPER(MY_FIELD) -> DON'T USE INDEX |
|---|---|
| Author | Sergio H. Gonzalez |
| Post date | 2008-04-22T15:20:44Z |
Hi Martijn! Thanks for the answer!
So with FB1.5 it's imposible to use an index for that? It's ok to do the
query anyway? How did you do it with 1.5? I think that most of the times the
user don't want know about the case when he is searching someting by its
name. Anyway, so far (with a table of 7000 records) the query runs very
fast, but I wander what would happen with a million records... Thanks
again!!! -sergio
So with FB1.5 it's imposible to use an index for that? It's ok to do the
query anyway? How did you do it with 1.5? I think that most of the times the
user don't want know about the case when he is searching someting by its
name. Anyway, so far (with a table of 7000 records) the query runs very
fast, but I wander what would happen with a million records... Thanks
again!!! -sergio
----- Original Message -----
Sent: Tuesday, April 22, 2008 12:10 PM
Subject: Re: [firebird-support] SELECT UPPER(MY_FIELD) -> DON'T USE INDEX
Hi,
In Firebird 2.0 you can, but not in 1.5.