Subject Re: [IBO] Why fetch all the records
Author Jason Wharton
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

----- Original Message -----
From: "Rohit Gupta" <rohit@...>
To: <>
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 :-)