Hi,

Yes, if I use LIKE :sString it is taking 00:00:00:0930
seconds

But if I hardcode it like LIKE 'GLAX%' it takes only
00:00:00:0050 seconds!
Ben


On Sun, 07 Jul 2002 Thomas Steinmaurer wrote :

>Ben,
>
> > Thanks for your reply.
> >
> > I am using only 'GLAX%', sString can be 'G%' or 'GL%' or
> > 'GLA%', the plan tab in IBConsole shows it is using index.
>
>So the query should be fast enough. Is there any other problem
>with the LIKE clause?
>
>
>Regards,
>Thomas Steinmaurer
>IB LogManager 2.0 - The Logging/Auditing Tool for InterBase and
>Firebird
>http://www.iblogmanager.com
>
>
>------------------------ Yahoo! Groups Sponsor
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to
>http://docs.yahoo.com/info/terms/
>
>

_________________________________________________________
There is always a better job for you at Monsterindia.com.
Go now http://monsterindia.rediff.com/jobs