What I uderstand is, simply by adding a new index for the field FECH, makes this query to go faster again, like it was before Firebird 2.5.4 in where something changed, making it does not use my compound index (FECH,MOVI) anymore.
Re: [firebird-support] Re: Query optimizer is not using the useful indexes.
[email protected] [firebird-support] Fri, 31 May 2019 10:44:55 -0700
- [firebi... 'Dany Schaer' [email protected] [firebird-support]
- Re... Dimitry Sibiryakov [email protected] [firebird-support]
- ... [email protected] [firebird-support]
- Re... setysvar [email protected] [firebird-support]
- ... [email protected] [firebird-support]
- [f... [email protected] [firebird-support]
- ... Dimitry Sibiryakov [email protected] [firebird-support]
- ... [email protected] [firebird-support]
- ... [email protected] [firebird-support]
- Re... liviuslivius [email protected] [firebird-support]
- ... [email protected] [firebird-support]
- ... Karol Bieniaszewski [email protected] [firebird-support]
- ... [email protected] [firebird-support]
- ... Omacht AndrĂ¡s [email protected] [firebird-support]
- ... [email protected] [firebird-support]
