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 re
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
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.
---
I got this plan for a query:
PLAN SORT (
JOIN (
JOIN (
JOIN (
BUPD NATURAL,
UPD INDEX ("IX_PK_Uppdatering"),
SP INDEX ("IX_Uppgiftsspärr_TilläG2M")
),
E INDEX ("IX_Epostadress_UppgiftLZH")
),
F NATURAL
)
)
Would this mean that t