It all depends.
I don't directly make use of indexes but if HDR is enabled it will depend on
what you are ordering the query by. Also, if it does a specific cursor
looking for a value's existence or not it may parse together another SQL.

If you want to know what indexes are being used for operations your best bet
is to watch things using the SQL trace monitor.

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

----- Original Message -----
From: <guido.klapperich@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, March 08, 2002 3:59 PM
Subject: Re: [IBO] Inc-search on 2 or more fields


> > No, you cannot.
> > Use Locate() with HDR and you will have excellent results just the same.
> >
>
> One last question concerning the indexes. I have Index1 on NAME, Index2 on
CITY
> and Index3 on NAME and CITY and I do a locate like
> Locate('NAME;CITY', VarArrayOf(['Media
Markt','Frankfurt']),[loCaseInsensitive])
>
> Which Index will be used ? I guess Index3, is this correct ?
>
>
> Guido