Subject Re: [firebird-support] Query Performance - correlated subqueries and group by statements
Author Jason Dodson
Assuming we have TableX and TableY, both with FieldA and FieldB, indexed:

Select *
From TableX Inner Join TableY on TableX.FieldA = TableY.FieldA
Where TableX.FieldB = TableY.FieldB

But seriously, I am just speculating.


Rick Debay wrote:
>>Firebird can use more than one index per table for a query
> In what cases could FB use more than one index on a table? My guess
> would be only for OR logic in the JOIN or WHERE clause. Are there any
> documents I could read on this, besides the FB Book?