X hits on this document

97 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 views97
Page views97
Page last viewedTue Dec 06 22:37:04 UTC 2016
Pages38
Paragraphs703
Words2667

Comments