Displaying posts tagged: subquery-factoring

Subquery Factoring and Global Views are Incompatible

No Comments
I've been enjoying the clean and organized look of Subquery Factoring for awhile now, despite some of the current limitations of the feature. But I've recently run into what appears to be very strange behavior when using a global view (gv$...) in a subquery. Upon reflection, this limitation is understandable, given the nature of global instance ...