subquery factoring questions.
Posted
by Sujee
on Stack Overflow
See other posts from Stack Overflow
or by Sujee
Published on 2010-06-03T03:38:39Z
Indexed on
2010/06/03
3:44 UTC
Read the original article
Hit count: 403
Hi,
Please explain.
a) is "subquery factoring" used to replace a non-correlated subquery? What about correlated subquery?
b) if it is true, are "subquery" and "subquery factoring" executed exactly once?
c) "subquery" vs "subquery factoring" which one is better
Thank you.
© Stack Overflow or respective owner