Hello,
I have a big table and its index built on column used on the "where clause".
I did alter table and index to keep in memory but results are still very slow.
Isolation Level is set to *NONE
It takes more than 6 seconds just to count rows when the "where clause" is in place and only 20ms when not in place.
[ 27/07/2023, 13:59:40 ] Run Selected...
SELECT count(*) FROM bms71t_dat.movmg00f
Statement ran successfully (20 ms)
[ 27/07/2023, 14:00:06 ] Run and Explain...
SELECT count(*) FROM bms71t_dat.movmg00f WHERE mgcazi='020'
Statement ran successfully (6,685 ms = 6.685 sec
I attach Visual Explain and it look good.
Any idea to improve performance?
Thanks
Giovanni
I have a big table and its index built on column used on the "where clause".
I did alter table and index to keep in memory but results are still very slow.
Isolation Level is set to *NONE
It takes more than 6 seconds just to count rows when the "where clause" is in place and only 20ms when not in place.
[ 27/07/2023, 13:59:40 ] Run Selected...
SELECT count(*) FROM bms71t_dat.movmg00f
Statement ran successfully (20 ms)
[ 27/07/2023, 14:00:06 ] Run and Explain...
SELECT count(*) FROM bms71t_dat.movmg00f WHERE mgcazi='020'
Statement ran successfully (6,685 ms = 6.685 sec
I attach Visual Explain and it look good.
Any idea to improve performance?
Thanks
Giovanni
Comment