Help to understand this sqexplain
Leandro Kohler had a query running for many hours and asked for help reading its SET EXPLAIN output, attaching the plan. Paul Watson asked him to post the plan. Eric Vercelletto asked that plans be pasted in the message text rather than attached, since many readers use email. No analysis or answer to the tuning question was given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
| view attached Hello, I have this query that is taking many hours to run. I made a setexplain of it but I can't understand where the problem is. I believe I should create some table indices but I don't know which tables ------------------------------ Leandro Kohler ------------------------------ #Informix
Maybe post the plan ?
Hi Paul, its attached ------------------------------ Leandro Kohler ------------------------------
QUERY ------------------------------ SELECT eis_v_cap_despesas.cod_empresa cod_empresa, SUM(eis_v_cap_despesas.val_tot_nf) val_tot_nf,eis_v_cap_despesas.den_nivel_2 den_nivel_2,eis_v_cap_despesas.den_nivel_4 den_nivel_4,eis_v_cap_despesas.raz_social raz_social,eis_v_cap_despesas.ano_mes ano_mes, SUM(eis_v_cap_despesas.valor) valor from eis_v_cap_despesas eis_v_cap_despesas WHERE 1=1 AND ((eis_v_cap_despesas.dat_pgto >= '07/01/2022' and eis_v_cap_despesas.dat_pgto <= '07/31/2022' ) and eis_v_cap_despesas.num_conta_contabil = '8.1000.04.09') --,'8.1100.04.10','10000409','11000410' )) GROUP BY eis_v_cap_despesas.cod_empresa,eis_v_cap_despesas.den_nivel_2,eis_v_cap_despesas.den_nivel_4,eis_v_cap_despesas.raz_social,eis_v_cap_despesas.ano_mes OUTPUT SETEXPLAIN: attached on post ------------------------------ Leandro Kohler ------------------------------ ------------------------------
Leandro, Many people receive those messages thru email and have either no time nor possibility to log into a webpage. So please post the query plan in the message and not as attached document if you want more people look at it Thanks Eric
Eric - this one you don't wanna see here as a post ;-) ------------------------------ Andreas Legner ------------------------------