I created a index on cep (cep_cidade, cep_endereco). Now the result is
faster.
Is it right to use this way? Can I find problems in the future creating
indexes?

----- Original Message -----
From: "Lucas Franzen" <luc@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, July 27, 2001 7:10 AM
Subject: Re: [IBO] Slow select...


> Acesso pelo menor preço do mercado! R$ 14,90 nos 3 primeiros meses!
> ASSINE AGORA! http://www.bol.com.br/acessobol/
>
>
>
> SET,
>
> Svein Erling Tysvær schrieb:
> >
> > Rejane,
> > Unlike STARTING WITH, LIKE can never use an index,
>
> not quite true.
>
> If you issue a statement like : "LIKE 'ABC%'" Interbase will use an
> index (since the optimizer seems to switch statements like these to
> STARTING WITH internally).
>
> Luc.
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>