Subject [IBO] Re: SQL plan in TIBOQuery
Author hubert_krukowski <hubert@agb.com.pl>
--- In IBObjects@yahoogroups.com, "Jason Wharton" <jwharton@i...>
wrote:
> Also remember, if it is pulling in too many indexes there are
tricks you can
> do to suppress their inclusion. For example:
>
> SELECT *
> FROM ATABLE
> WHERE ACOLUMN + 0 = AVALUE
>
> Adding the + 0 will make it so that the optimizer will not include
an index
> for that column.

The WHERE clause is provided by the OrderingLinks/OrderingItems
feature and not by me.

Regards,

Hubert Krukowski