X hits on this document

101 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 views101
Page views101
Page last viewedThu Dec 08 02:42:58 UTC 2016
Pages38
Paragraphs703
Words2667

Comments