Re: [firebird-support] How I can speed up this query

Hallo, Il 13/10/2017 21.33, 'Daniel Miller' dmil...@amfes.com [firebird-support] ha scritto: > It would be interesting to compare the plans for both your original query syntax and Set's suggestion - see where the difference is. Original: PLAN (PNC2 NATURAL) PLAN JOIN (PNC NATURAL, PNT

Re[2]: [firebird-support] How I can speed up this query

On 10/12/2017 12:24:11 AM, "Luigi Siciliano luigi...@tiscalinet.it [firebird-support]" wrote: >Hallo, > >Il 11/10/2017 20.38, setysvar setys...@gmail.com [firebird-support] ha >scritto: >>I think this should give the same result as your query, whether or not

Re: [firebird-support] How I can speed up this query

Hallo, Il 11/10/2017 20.38, setysvar setys...@gmail.com [firebird-support] ha scritto: > I think this should give the same result as your query, whether or not > it is any quicker, I simply do not know (but I would love to hear if it > made any difference). Your query is to slow, flamerobin

Re: [firebird-support] How I can speed up this query

11.10.2017 19:43, Luigi Siciliano wrote: > Hallo, > > I have this query > > SELECT > ID, > DENOMINAZIONE, > SCADENZA, > PARTITA, > NUMERO_DOCUMENTO, > DATA_DOCUMENTO, > IMPORTO, > IMPORTO - PAGATO AS RESIDUO, > PAGATO, > PAGAMENTO, > SALDARE > from > ( >

[firebird-support] How I can speed up this query

Hallo, I have this query SELECT   ID,   DENOMINAZIONE,   SCADENZA,   PARTITA,   NUMERO_DOCUMENTO,   DATA_DOCUMENTO,   IMPORTO,   IMPORTO - PAGATO AS RESIDUO,   PAGATO,   PAGAMENTO,   SALDARE from ( SELECT   C.ID,   C.DENOMINAZIONE,   PNS.SCADENZA,   PNS.PARTITA,