X hits on this document

113 views

0 shares

0 downloads

0 comments

10 / 38

10

juliandyke.com

© 2007 Julian Dyke

Result Cache Subqueries versus Views

Subquery result sets cannot be cached

Views and inline views can be cached

Adding RESULT_CACHE hint to an inline view disables optimizations between outer query and inline view to maximize reusability of cached result

Document info
Document views113
Page views113
Page last viewedSun Dec 11 06:04:34 UTC 2016
Pages38
Paragraphs703
Words2667

Comments