|Subject||Re: [firebird-support] Query taking too much time|
> Or look at the redundancy in your master-detail structure andOr provide combined indices on (BillNumber,BillType) for the join.
> simply ignore BILLTYPE. Presumably, the master can't have multiple
> billtypes, so all of the billitemdetails will be of the same
> billtype without needing to join on it.
But, I would also assum "billtype" to be redundant here.