X hits on this document

141 views

0 shares

0 downloads

0 comments

11 / 38

11

juliandyke.com

© 2007 Julian Dyke

SQL Query Result Cache Example Statement

Example query

SELECT /*+ RESULT_CACHE */ t.team_name, SUM (c.team_points) FROM car c, team t WHERE c.team_key = t.team_key AND c.season_key = '2006' GROUP BY t.team_name ORDER BY SUM (c.team_points) DESC;

Document info
Document views141
Page views143
Page last viewedFri Jan 20 12:16:31 UTC 2017
Pages38
Paragraphs703
Words2667

Comments