With InterBase it only can use the fields. I get the fields from the index
and use them. The only place an index name can appear in a SELECT statement
is in the PLAN clause and I generally always try to avoid them.

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

----- Original Message -----
From: "Rohit Gupta" <rohit@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, February 27, 2001 8:52 PM
Subject: Re: [IBO] Why fetch all the records


> Last is teh problme in osme of them then. I suspect that the real culprit
> is that the ibotable translates the indexname supplied to fields and the
> select statement uses the fields rather than the index. I will have to
> inspect the monitor logs and play with the plan some more :-)