|
Posted by SB on 05/14/07 09:24
> My understanding of this is that the count(*) is only executed ONCE,
> and that the nested loop then combines the result (EXPR1006) with all
> keys obtained by scanning the primary key index. Or in other words
> that the single-"row" result of the count(*) is chosen as the "table"
> that drives the loop.
Maybe I am wrong but I think it is other way around. It puts the sql
statement in a nested loop and count(*) is executed many times.
Navigation:
[Reply to this message]
|