| Subject | Re: [firebird-support] Help in optimizing big data query |
|---|---|
| Author | Iwan Cahyadi Sugeng |
| Post date | 2019-04-23T04:45:53Z |
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 liviuslivius@... [firebird-support] <firebird-support@yahoogroups.com> wrote: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