Re: [firebird-support] Help interpret plan
Den 2019-06-12 kl. 13:40, skrev Svein Erling Tysvær setys...@gmail.com [firebird-support]: > How many records are there in BUPD, are the other indexes in the plan > selective and can you show us the query? Just wondering if it can be > rewritten so that the query performs better (I assume the reason for > you asking about the plan being that you have a query that is too slow). I could, but there's a left join to F on one col = col from join OR other col in (subselect with where on other col from join), which I don't really think could be improved. I decided to ignore the result of the query. I can achieve what I need by other means. Thanks anyway! To you too Dimitry, for confirming how to interpret the plan, which I have generic use for. :-) Regards, Kjell [Non-text portions of this message have been removed]
Re: [firebird-support] Help interpret plan
How many records are there in BUPD, are the other indexes in the plan selective and can you show us the query? Just wondering if it can be rewritten so that the query performs better (I assume the reason for you asking about the plan being that you have a query that is too slow). Set ons. 12. jun. 2019 kl. 12:38 skrev Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] : > 12.06.2019 12:37, Kjell Rilbe kjell.ri...@marknadsinformation.se > [firebird-support] wrote: > > Would this mean that the table F would be subject to a full natural scan > > for each record of the preceding joins? > >Yes. > > > -- >WBR, SD. > > > > > > > ++ > > 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 > > > >
Re: [firebird-support] Help interpret plan
12.06.2019 12:37, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Would this mean that the table F would be subject to a full natural scan > for each record of the preceding joins? Yes. -- WBR, SD. ++ 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: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
