| Subject | Re: [firebird-support] Re: query optimization- MAX() from .. WHERE |
|---|---|
| Author | Helen Borrie |
| Post date | 2010-08-18T10:43:37Z |
At 10:25 PM 18/08/2010, you wrote:
If so, test the benefit of placing a descending index on both (but not a compound descending index involving both).
./heLen
>>That seems to tell us that FOREIGN_KEY and NUMER both increase systematically as the database grows...is that the case?
>> Take FOREIGN_KEY out of that index!
>>
>> ./heLen
>>
>
>It doubles reads amount.
If so, test the benefit of placing a descending index on both (but not a compound descending index involving both).
./heLen