X hits on this document

153 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 views153
Page views155
Page last viewedMon Jan 23 13:38:36 UTC 2017
Pages38
Paragraphs703
Words2667

Comments