HiAs you can see, your query do not use any index for filter records. You got indexed reads only for order by. The obvius question is what about creating index on e.g KODE_MESIN. Regards,Karol Bieniaszewski null
Re: [firebird-support] Help in optimizing big data query
liviuslivius liviusliv...@poczta.onet.pl [firebird-support] Mon, 22 Apr 2019 21:35:14 -0700
- [firebird-s... Iwan Cahyadi Sugeng iwan.c.sug...@gmail.com [firebird-support]
- Re: [f... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
- Re: [f... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
- Re... Iwan Cahyadi Sugeng iwan.c.sug...@gmail.com [firebird-support]
- Re: [f... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
- Re... Iwan Cahyadi Sugeng iwan.c.sug...@gmail.com [firebird-support]