Re: Lost Connection or Running too long
[table]
[tr]
[td]id[/td]
[td]select_type[/td]
[td]table[/td]
[td]partitions[/td]
[td]type[/td]
[td]possible_keys[/td]
[td]key[/td]
[td]key_len[/td]
[td]ref[/td]
[td]rows[/td]
[td]filtered[/td]
[td]Extra[/td]
[/tr]
[tr]
[td]1[/td]
[td]PRIMARY[/td]
[td]comfidi_cr_aggregati[/td]
[td]null[/td]
[td]ALL[/td]
[td]null[/td]
[td]null[/td]
[td]null[/td]
[td]null[/td]
[td]4957025[/td]
[td]27.10[/td]
[td]Using where[/td]
[/tr]
[tr]
[td]2[/td]
[td]UNION[/td]
[td]comfidi_cr_aggregati[/td]
[td]null[/td]
[td]ALL[/td]
[td]null[/td]
[td]null[/td]
[td]null[/td]
[td]null[/td]
[td]4957025[/td]
[td]19.00[/td]
[td]Using where; Using temporary: Using filesort[/td]
[/tr]
[tr]
[td]null[/td]
[td]UNION RESULT[/td]
[td]<union1.2>[/td]
[td]null[/td]
[td]ALL[/td]
[td]null[/td]
[td]null[/td]
[td]null[/td]
[td]null[/td]
[td]null[/td]
[td]null[/td]
[td]Using temporary[/td]
[/tr]
[/table]
I was not able to find the my.cnf/ini file, please give me some instructions if you need it still. I searched in C:\WINDOWS\ directory but neither my.cnf/ini nor my.ini !
(REFERENCE TABLE) comfidi_cr_aggregati TABLE:
[table]
[tr]
[td]NR_CR[/td]
[td]PERIODO_RIF[/td]
[td]CATEGORIA[/td]
[td]ACCORDATO[/td]
[td]ACC_OPERATIVO[/td]
[td]UTILIZZATO[/td]
[td]SALDO_MEDIO[/td]
[td]VAL_GARANZIA[/td]
[td]IMPORTO_GAR[/td]
[td]VAL_INTRINSECO[/td]
[td]ALTRI_IMPORTI[/td]
[td]SCONFINAMENTO[/td]
[/tr]
[tr]
[td]10924921[/td]
[td]201301[/td]
[td]550600[/td]
[td]125000[/td]
[td]125000[/td]
[td]131662[/td]
[td]127467[/td]
[td]0[/td]
[td]0[/td]
[td]0[/td]
[td]0[/td]
[td]8067[/td]
[/tr]
[/table]
Subject
Written By
Posted
Re: Lost Connection or Running too long
June 02, 2017 09:36AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.