tag:blogger.com,1999:blog-9154833686311218941.post2495898046217007859..comments2023-05-21T05:15:07.263-07:00Comments on All About Databases: Oracle: Correlated sub-queries effectivenessNitin Aggarwalhttp://www.blogger.com/profile/10715838206476296982noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-9154833686311218941.post-77519792923159577242010-04-29T22:10:22.281-07:002010-04-29T22:10:22.281-07:00Hi Ashok,
Please refer to:
http://publib.boulder....Hi Ashok,<br /><br />Please refer to:<br />http://publib.boulder.ibm.com/infocenter/rbhelp/v6r3/index.jsp?topic=/com.ibm.redbrick.doc6.3/sqlrg/sqlrg44.htm<br /><br />Excerpts:<br />------------------------<br />A scalar subquery returns a single scalar value (one column, one row) and can occur either in a select list or in a condition as an argument of a comparison operator.<br /><br />A correlated subquery, however, contains cross-references to the parent query that can force the execution of the subquery each time the parent retrieves a new row.Nitin Aggarwalhttps://www.blogger.com/profile/10715838206476296982noreply@blogger.comtag:blogger.com,1999:blog-9154833686311218941.post-6559535632683079862010-04-29T18:15:23.003-07:002010-04-29T18:15:23.003-07:00Hi Nitin,
Good one...small correction tho..
These ...Hi Nitin,<br />Good one...small correction tho..<br />These are known as Scalar sub-queries, not correlated sub-queries.<br /><br />Thanks,<br />AshokAnonymousnoreply@blogger.com