Re: [firebird-support] Help in optimizing big data query

[Iwan Cahyadi Sugeng iwan.c.sug...@gmail.com [firebird-support]]

Hi,

The data is repeated and most records are empty value, it will be filled
after a process. But will try to add index on it

Thank you

On Tue, Apr 23, 2019 at 11:35 AM liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] <firebird-support@yahoogroups.com> wrote:

>
>
> Hi
>
> As 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
>
> 
>