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: 405

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

Related posts about sql

Related posts about Oracle