Hallo, Il 11/10/2017 20.38, setysvar [email protected] [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 -------------------------- ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
