Subject | [IBO] Re: SQL plan in TIBOQuery |
---|---|
Author | hubert_krukowski <hubert@agb.com.pl> |
Post date | 2003-02-04T09:40:18Z |
--- In IBObjects@yahoogroups.com, "Jason Wharton" <jwharton@i...>
wrote:
feature and not by me.
Regards,
Hubert Krukowski
wrote:
> Also remember, if it is pulling in too many indexes there aretricks you can
> do to suppress their inclusion. For example:an index
>
> SELECT *
> FROM ATABLE
> WHERE ACOLUMN + 0 = AVALUE
>
> Adding the + 0 will make it so that the optimizer will not include
> for that column.The WHERE clause is provided by the OrderingLinks/OrderingItems
feature and not by me.
Regards,
Hubert Krukowski