Looks to me like you could use the full text searching capabilities of IBO4.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <rejanem@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, July 26, 2001 12:42 PM
Subject: [IBO] Slow select...


Hello,

I'm with a problem in this Select:

select c.cep_codigo,
c.cep_cep8,
c.cep_endereco,
c.cep_endereco_tipo,
c.cep_complemento,
c.cep_cidade,
c.cep_bairro,
(select b.bai_nome from bairro b where
b.bai_codigo=c.cep_bairro) as bairro
from cep c
where cep_cidade = 124
and cep_endereco like '%ABACATE%'

It's very slow, my table has 576.380 registries.

But if I use the same sql without the operator 'like',
the sql is fast!

Is there another way that I can filter the
field 'cep_endereco' without using the operator 'like'
that return me the result highest?

Thanks

Rejane


__________________________________________________________________________
Acesso pelo menor preço do mercado! R$ 14,90 nos 3 primeiros meses!
ASSINE AGORA! http://www.bol.com.br/acessobol/






Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/