Hallo,

Il 11/10/2017 20.38, setysvar setysvar@... [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 tells 4.360s. :(

> PLAN (PNC2 NATURAL)
>
> seems to be your problem (PNC on the other hand, seems OK).
>
> Hence, if PARITA and/or SCADENZA are selective, I would recommend that
> you create an index for either or both of these fields. That way, I
> would assume your original query to become a lot quicker.

Ok, I create an index for PARTITA and SCADENZA fields for PNC and Your
query speed up, Flamerobin now tells 0.060s :)

And, my query, now, flamerobin tells 0.045s :))

The secondary index are automatically maintained by server, is it right
to do a periodically manually maintenance for it's?

Thanks
--

Luigi Siciliano
--------------------------