| Subject | Re: [firebird-support] Help interpret plan |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2019-06-12T11:40:52Z |
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 sd@... [firebird-support] <firebird-support@yahoogroups.com>:
12.06.2019 12:37, Kjell Rilbe kjell.rilbe@... [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-digest@yahoogroups.com
firebird-support-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/