X hits on this document

150 views

0 shares

0 downloads

0 comments

12 / 38

12

juliandyke.com

© 2007 Julian Dyke

SQL Query Result Cache Example Execution Plan

0SELECT STATEMENT 10RESULT CACHEdbzqh4r21zn0wc8zwfcvg00sqw 21SORT (ORDER BY) 32HASH (GROUP BY) 43MERGE JOIN 54TABLE ACCESS (BY INDEX ROWID) OF 'TEAM' 65INDEX (FULL SCAN) OF 'TEAM_PK' 74SORT (JOIN) 87TABLE ACCESS (BY INDEX ROWID) OF 'CAR' 98INDEX (RANGE SCAN) OF 'CAR_PK'

Result Cache Information (identified by operation id):  1 - column count=2; dependencies=(GP.CAR, GP.TEAM); parameters=(nls); name = "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 = "

Document info
Document views150
Page views152
Page last viewedMon Jan 23 04:46:43 UTC 2017
Pages38
Paragraphs703
Words2667

Comments