judlian23 wrote:

>
>
> Is there a way to do hash indexing?

No - Firebird supports only b*tree indexes. For more information
try here: http://www.ibphoenix.com/main.nfs?page=ibp_expert1

> Is there a way to specify the compound indexing?

I'm not quite sure what you mean. If you have a table with
two indexes (neither of them unique) and your query provides
conjuncts that apply to both indexes, Firebird will use both
indexes in resolving the query. It's automatic.


Regards,

Ann