Hi,

> Is there a way to provide hints to firebird as to what index it
> should use (/*+ use_hash(txt_qjtable stk_stock_dict)*/) to compute
> the results of a SELECT query.

You can force a PLAN, but you shouldn't.

Better explain why you think you need to do this.

Show us the DDL, the query and the current plan.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com