All pastes #475850 Raw Edit

seanr_

public text v1 · immutable
·published 2007-05-07 18:52 UTC
rendered paste body
<BASE HREF="file:///C:\oracle\ora92/sysman/report/LOLI_SELECT_759618676/index.html">
<HTML>
<HEAD>
<TITLE>Oracle SQL Explain Plan</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html">
<META HTTP-EQUIV="PRAGMA" CONTENT="no-cache">
<META NAME="robots" CONTENT="NONE">
<META NAME="generator" CONTENT="Oracle Enterprise Manager Reporting Framework">
</HEAD>
<BODY BGCOLOR="white">
<IMG align=top height=72 src="../../reporting/gif/oem.gif" ALT="Oracle Enterprise Manager" width=320><BR CLEAR="all">
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%"><TR>
<TD align="left" bgColor=#336699 height=21 vAlign="top" width=9><IMG height=1 src="../../reporting/gif/space.gif" ALT="" width=1></TD>
<TD align="left" bgColor=#336699 height=21 vAlign="top" width=20><IMG height=1 src="../../reporting/gif/space.gif" ALT="" width=1></TD>
<TD align="left" bgColor=#336699 height=21><FONT face="Arial, Helvetica, sans-serif" color=#ffffff size="+2"><B>Oracle SQL Explain Plan</B></FONT></TD>
<TD bgColor=#336699 height=21 align="right"><FONT face="Arial, Helvetica, sans-serif" color=#ffffff><B>May 7, 2007 11:29:33 AM PDT</B></FONT>&nbsp;</TD>
<TD align="left" background="../../reporting/gif/rhshadow.gif" vAlign="top" width=5><IMG height=1 src="../../reporting/gif/space.gif" ALT="" width=7></TD>
</TR><TR>
<TD align="left" bgColor=#336699 height=16 vAlign=top width=9><IMG height=1 src="../../reporting/gif/space.gif" ALT="" width=1></TD>
<TD align="left" bgColor=#336699 height=16 vAlign=top width=11><IMG height=1 src="../../reporting/gif/space.gif" ALT="" width=1></TD>
<TD align="left" background="../../reporting/gif/bot.gif" bgColor=#ffffff height=16 vAlign=top colspan=2><IMG align=top height=16 src="../../reporting/gif/toparch.gif" ALT="" width=26></TD>
<TD align="left" height=16 vAlign="top" width=5><IMG height=8 src="../../reporting/gif/rend.gif" ALT="" width=8></TD>
</TR><TR>
<TD align="right" height=8 vAlign="top" width=9><IMG height=8 src="../../reporting/gif/lend.gif" ALT="" width=10></TD>
<TD align="right" background="../../reporting/gif/bot.gif" height=8 vAlign=top width=11><IMG height=1 src="../../reporting/gif/space.gif" ALT="" width=1></TD>
<TD align="left" bgColor=#ffffff height=8 vAlign=top width=2100 colspan=2><IMG height=8 src="../../reporting/gif/archcorn.gif" ALT="" width=6></TD>
<TD align="right" height=8 vAlign=top width=5><IMG height=1 src="../../reporting/gif/space.gif" ALT="" width=1></TD>
</TR></TABLE><P>
<H2>Target:</H2>
&nbsp;&nbsp;&nbsp;&nbsp;<B>LOLI</B><BR>
<P>
<table border=0 cellPadding=0 cellSpacing=0 width=634><tbody><tr><td width=3%>&nbsp;</td><td align=right vAlign=top width=97%><p><font color=#336699><b><font size=2>Version: Oracle 9.2.0.1.0</font></b></font></p></td></tr><tr><td width=3%>&nbsp;</td><td align=right vAlign=top width=97%><p><font color=#336699><b><font size=2>Database: LOLI</font></b></font></p></td></tr><tr><td width=3%>&nbsp;</td><td align=right vAlign=top width=97%><p><font color=#336699><b><font size=2>Schema: HSP</font></b></font></p></td></tr><tr><td width=3%>&nbsp;</td><td align=right vAlign=top width=97%><p><font color=#336699><b><font size=2>Date: 07-May-07 4:00:00 PM</font></b></font></p></td></tr></tbody></table><br><font size=4 color=#336699><b>SQL Statement:</b></font><br><br><table width=634><tr><td width=2%>&nbsp;&nbsp;</td><td bgColor=#f7f7e7><pre><code>SELECT DISTINCT organization.org_key, organization.org_name
    FROM organization, assigned_exam_rpt_data
    WHERE organization.parent_org_key = 1076
      AND assigned_exam_rpt_data.organization_key = organization.org_key
      AND assigned_exam_rpt_data.subject = 1
      AND assigned_exam_rpt_data.graded_date IS NOT NULL
      AND assigned_exam_rpt_data.class_active_status = 1
      AND assigned_exam_rpt_data.student_active_status = 1</code></pre></td></tr></table><br><font size=4 color=#336699><b>Optimizer Mode Used:</b></font><br><br><table width=634><tr><td width=2%>&nbsp;&nbsp;</td><td bgColor=#f7f7e7><font size=3>COST ALL ROWS (optimizer: CHOOSE)</font></td></tr></table><br><font size=4 color=#336699><b>Total Cost:</b></font><br><br><table width=634><tr><td width=2%>&nbsp;&nbsp;</td><td bgColor=#f7f7e7><font size=3>4,221</font></td></tr></table><br><font size=4 color=#336699><b>Execution Steps:</b></font><br><br><table border=0 cellPadding=0 cellSpacing=0 cols=3 width=650 summary="This table provides a high level overview of the execution steps in the plan by mapping step numbers to step names.  The step numbers are linked to a detail table below."><tr><th bgColor=#cccc99 width=40><b><font color=#336699 face="Arial, Helvetica, sans-serif" size=2>Step #</font></b></th><th bgColor=#cccc99 width=594><b><font color=#336699 face="Arial, Helvetica, sans-serif" size=2>Step Name</font></b></th></tr></table><a name="planStep22"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step22">22</a></font></td><td noWrap align=left vAlign=top width=16><img alt="" align=top border=0 src=1_1.gif width=16></td><td align=left width=594><font size=3>SELECT STATEMENT</font></td></tr></table><a name="planStep21"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step21">21</a></font></td><td noWrap align=left vAlign=top width=32><img alt="" align=top border=0 height=100% src=1_2.gif width=16><img alt="" align=top border=0 src=1_3.gif width=16></td><td align=left width=578><font size=3>SORT [UNIQUE]</font></td></tr></table><a name="planStep20"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step20">20</a></font></td><td noWrap align=left vAlign=top width=48><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_4.gif width=16><img alt="" align=top border=0 src=1_6.gif width=16></td><td align=left width=562><font size=3>HASH JOIN</font></td></tr></table><a name="planStep1"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step1">1</a></font></td><td noWrap align=left vAlign=top width=64><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_7.gif width=16><img alt="" align=top border=0 src=1_8.gif width=16></td><td align=left width=546><font size=3>HSP.CLASS_PD TABLE ACCESS [FULL]</font></td></tr></table><a name="planStep19"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step19">19</a></font></td><td noWrap align=left vAlign=top width=64><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_9.gif width=16><img alt="" align=top border=0 src=1_6.gif width=16></td><td align=left width=546><font size=3>HASH JOIN</font></td></tr></table><a name="planStep2"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step2">2</a></font></td><td noWrap align=left vAlign=top width=80><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_10.gif width=16><img alt="" align=top border=0 src=1_8.gif width=16></td><td align=left width=530><font size=3>HSP.EXAM TABLE ACCESS [FULL]</font></td></tr></table><a name="planStep18"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step18">18</a></font></td><td noWrap align=left vAlign=top width=80><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_11.gif width=16><img alt="" align=top border=0 src=1_6.gif width=16></td><td align=left width=530><font size=3>HASH JOIN</font></td></tr></table><a name="planStep16"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step16">16</a></font></td><td noWrap align=left vAlign=top width=96><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_12.gif width=16><img alt="" align=top border=0 src=1_13.gif width=16></td><td align=left width=514><font size=3>NESTED LOOPS [OUTER]</font></td></tr></table><a name="planStep14"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step14">14</a></font></td><td noWrap align=left vAlign=top width=112><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_15.gif width=16><img alt="" align=top border=0 height=100% src=1_14.gif width=16><img alt="" align=top border=0 src=1_13.gif width=16></td><td align=left width=498><font size=3>NESTED LOOPS</font></td></tr></table><a name="planStep12"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step12">12</a></font></td><td noWrap align=left vAlign=top width=128><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_15.gif width=16><img alt="" align=top border=0 height=100% src=1_16.gif width=16><img alt="" align=top border=0 height=100% src=1_7.gif width=16><img alt="" align=top border=0 src=1_6.gif width=16></td><td align=left width=482><font size=3>HASH JOIN</font></td></tr></table><a name="planStep4"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step4">4</a></font></td><td noWrap align=left vAlign=top width=144><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_15.gif width=16><img alt="" align=top border=0 height=100% src=1_16.gif width=16><img alt="" align=top border=0 height=100% src=1_17.gif width=16><img alt="" align=top border=0 height=100% src=1_10.gif width=16><img alt="" align=top border=0 src=1_8.gif width=16></td><td align=left width=466><font size=3>HSP.ORGANIZATION TABLE ACCESS [BY INDEX ROWID]</font></td></tr></table><a name="planStep3"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step3">3</a></font></td><td noWrap align=left vAlign=top width=160><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_15.gif width=16><img alt="" align=top border=0 height=100% src=1_16.gif width=16><img alt="" align=top border=0 height=100% src=1_17.gif width=16><img alt="" align=top border=0 height=100% src=1_18.gif width=16><img alt="" align=top border=0 height=100% src=1_2.gif width=16><img alt="" align=top border=0 src=1_19.gif width=16></td><td align=left width=450><font size=3>HSP.ORGANIZATION_PARENT_ORG INDEX [RANGE SCAN]</font></td></tr></table><a name="planStep11"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step11">11</a></font></td><td noWrap align=left vAlign=top width=144><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_15.gif width=16><img alt="" align=top border=0 height=100% src=1_16.gif width=16><img alt="" align=top border=0 height=100% src=1_17.gif width=16><img alt="" align=top border=0 height=100% src=1_11.gif width=16><img alt="" align=top border=0 src=1_6.gif width=16></td><td align=left width=466><font size=3>HASH JOIN</font></td></tr></table><a name="planStep5"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step5">5</a></font></td><td noWrap align=left vAlign=top width=160><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_15.gif width=16><img alt="" align=top border=0 height=100% src=1_16.gif width=16><img alt="" align=top border=0 height=100% src=1_17.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_12.gif width=16><img alt="" align=top border=0 src=1_8.gif width=16></td><td align=left width=450><font size=3>HSP.ASSN_EXAM_DATA TABLE ACCESS [FULL]</font></td></tr></table><a name="planStep10"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step10">10</a></font></td><td noWrap align=left vAlign=top width=160><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_15.gif width=16><img alt="" align=top border=0 height=100% src=1_16.gif width=16><img alt="" align=top border=0 height=100% src=1_17.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_2.gif width=16><img alt="" align=top border=0 src=1_6.gif width=16></td><td align=left width=450><font size=3>HASH JOIN [OUTER]</font></td></tr></table><a name="planStep8"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step8">8</a></font></td><td noWrap align=left vAlign=top width=176><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_15.gif width=16><img alt="" align=top border=0 height=100% src=1_16.gif width=16><img alt="" align=top border=0 height=100% src=1_17.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_14.gif width=16><img alt="" align=top border=0 src=1_6.gif width=16></td><td align=left width=434><font size=3>HASH JOIN [OUTER]</font></td></tr></table><a name="planStep6"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step6">6</a></font></td><td noWrap align=left vAlign=top width=192><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_15.gif width=16><img alt="" align=top border=0 height=100% src=1_16.gif width=16><img alt="" align=top border=0 height=100% src=1_17.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_16.gif width=16><img alt="" align=top border=0 height=100% src=1_7.gif width=16><img alt="" align=top border=0 src=1_8.gif width=16></td><td align=left width=418><font size=3>HSP.ASSN_EXAM_STAN TABLE ACCESS [FULL]</font></td></tr></table><a name="planStep7"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step7">7</a></font></td><td noWrap align=left vAlign=top width=192><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_15.gif width=16><img alt="" align=top border=0 height=100% src=1_16.gif width=16><img alt="" align=top border=0 height=100% src=1_17.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_16.gif width=16><img alt="" align=top border=0 height=100% src=1_9.gif width=16><img alt="" align=top border=0 src=1_8.gif width=16></td><td align=left width=418><font size=3>HSP.ASSIGNMENT TABLE ACCESS [FULL]</font></td></tr></table><a name="planStep9"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step9">9</a></font></td><td noWrap align=left vAlign=top width=176><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_15.gif width=16><img alt="" align=top border=0 height=100% src=1_16.gif width=16><img alt="" align=top border=0 height=100% src=1_17.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_4.gif width=16><img alt="" align=top border=0 src=1_8.gif width=16></td><td align=left width=434><font size=3>HSP.BASE_USER TABLE ACCESS [FULL]</font></td></tr></table><a name="planStep13"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step13">13</a></font></td><td noWrap align=left vAlign=top width=128><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_15.gif width=16><img alt="" align=top border=0 height=100% src=1_16.gif width=16><img alt="" align=top border=0 height=100% src=1_9.gif width=16><img alt="" align=top border=0 src=1_19.gif width=16></td><td align=left width=482><font size=3>HSP.SYS_C006878 INDEX [UNIQUE SCAN]</font></td></tr></table><a name="planStep15"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step15">15</a></font></td><td noWrap align=left vAlign=top width=112><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_15.gif width=16><img alt="" align=top border=0 height=100% src=1_4.gif width=16><img alt="" align=top border=0 src=1_19.gif width=16></td><td align=left width=498><font size=3>HSP.SYS_C006728 INDEX [UNIQUE SCAN]</font></td></tr></table><a name="planStep17"> </a><table bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=650><tr><td align=center noWrap vAlign=top width=40><font size=3><a href="#step17">17</a></font></td><td noWrap align=left vAlign=top width=96><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_5.gif width=16><img alt="" align=top border=0 height=100% src=1_2.gif width=16><img alt="" align=top border=0 src=1_8.gif width=16></td><td align=left width=514><font size=3>HSP.BASE_USER TABLE ACCESS [FULL]</font></td></tr></table><br><table cols=5 width=634 summary="This table maps step numbers to step details including a step description, an optional cost value, an optional estimated number of rows returned, and an optional estimated number of bytes returned."><tr><th bgColor=#cccc99 width=40><b><font color=#336699 face="Arial, Helvetica, sans-serif" size=2>Step #</font></b></th><th bgColor=#cccc99 width=384><b><font color=#336699 face="Arial, Helvetica, sans-serif" size=2>Description</font></b></th><th bgColor=#cccc99 width=50><b><font color=#336699 face="Arial, Helvetica, sans-serif" size=2>Est. Cost</font></b></th><th bgColor=#cccc99 width=70><b><font color=#336699 face="Arial, Helvetica, sans-serif" size=2>Est. Rows Returned</font></b></th><th bgColor=#cccc99 width=90><b><font color=#336699 face="Arial, Helvetica, sans-serif" size=2>Est. KBytes Returned</font></b></th></tr></table><a name="step1"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep1"><font size=3>1</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step retrieves all rows from table CLASS_PD.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>19</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>14,534</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>113.547</font></td></tr></table><a name="step2"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep2"><font size=3>2</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step retrieves all rows from table EXAM.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>19</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>2,213</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>12.967</font></td></tr></table><a name="step3"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep3"><font size=3>3</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step retrieves one or more ROWIDs in ascending order by scanning the B*-tree index ORGANIZATION_PARENT_ORG.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>1</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>950</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>--</font></td></tr></table><a name="step4"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep4"><font size=3>4</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step retrieves rows from table ORGANIZATION through ROWID(s) returned by an index.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>2</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>5</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>0.156</font></td></tr></table><a name="step5"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep5"><font size=3>5</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step retrieves all rows from table ASSN_EXAM_DATA.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>1,095</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>766,185</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>12,719.868</font></td></tr></table><a name="step6"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep6"><font size=3>6</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step retrieves all rows from table ASSN_EXAM_STAN.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>346</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>486,561</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>11,403.773</font></td></tr></table><a name="step7"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep7"><font size=3>7</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step retrieves all rows from table ASSIGNMENT.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>19</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>22,885</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>156.44</font></td></tr></table><a name="step8"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep8"><font size=3>8</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step accepts two sets of rows, each from a different table.  A hash table is built using the rows returned by the first child.  Each row returned by the second child is then used to probe the hash table to find row pairs which satisfy a condition specified in the query's WHERE clause.  Note: The Oracle cost-based optimizer will build the hash table using what it thinks is the smaller of the two tables.  It uses the statistics to determine which is smaller, so out of date statistics could cause the optimizer to make the wrong choice.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>806</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>486,561</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>14,729.874</font></td></tr></table><a name="step9"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep9"><font size=3>9</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step retrieves all rows from table BASE_USER.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>189</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>159,656</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>1,403.227</font></td></tr></table><a name="step10"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep10"><font size=3>10</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step accepts two sets of rows, each from a different table.  A hash table is built using the rows returned by the first child.  Each row returned by the second child is then used to probe the hash table to find row pairs which satisfy a condition specified in the query's WHERE clause.  Note: The Oracle cost-based optimizer will build the hash table using what it thinks is the smaller of the two tables.  It uses the statistics to determine which is smaller, so out of date statistics could cause the optimizer to make the wrong choice.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>1,592</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>486,561</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>19,006.289</font></td></tr></table><a name="step11"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep11"><font size=3>11</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step accepts two sets of rows, each from a different table.  A hash table is built using the rows returned by the first child.  Each row returned by the second child is then used to probe the hash table to find row pairs which satisfy a condition specified in the query's WHERE clause.  Note: The Oracle cost-based optimizer will build the hash table using what it thinks is the smaller of the two tables.  It uses the statistics to determine which is smaller, so out of date statistics could cause the optimizer to make the wrong choice.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>3,885</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>486,561</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>27,083.962</font></td></tr></table><a name="step12"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep12"><font size=3>12</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step accepts two sets of rows, each from a different table.  A hash table is built using the rows returned by the first child.  Each row returned by the second child is then used to probe the hash table to find row pairs which satisfy a condition specified in the query's WHERE clause.  Note: The Oracle cost-based optimizer will build the hash table using what it thinks is the smaller of the two tables.  It uses the statistics to determine which is smaller, so out of date statistics could cause the optimizer to make the wrong choice.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>3,901</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>3,418</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>297.072</font></td></tr></table><a name="step13"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep13"><font size=3>13</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step retrieves a single ROWID from the B*-tree index SYS_C006878.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>--</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>1</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>0.004</font></td></tr></table><a name="step14"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep14"><font size=3>14</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step joins two sets of rows by iterating over the driving, or outer, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child).  Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>3,901</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>3,397</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>308.517</font></td></tr></table><a name="step15"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep15"><font size=3>15</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step retrieves a single ROWID from the B*-tree index SYS_C006728.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>--</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>1</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>0.003</font></td></tr></table><a name="step16"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep16"><font size=3>16</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step joins two sets of rows by iterating over the outer, or driving, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child).  Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause; in addition to the rows satisfying that condition, Oracle also returns all rows from the row set not containing the outer join operator (+) which failed to satisfy that condition.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>3,901</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>3,397</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>318.469</font></td></tr></table><a name="step17"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep17"><font size=3>17</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step retrieves all rows from table BASE_USER.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>189</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>79,828</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>623.656</font></td></tr></table><a name="step18"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep18"><font size=3>18</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step accepts two sets of rows, each from a different table.  A hash table is built using the rows returned by the first child.  Each row returned by the second child is then used to probe the hash table to find row pairs which satisfy a condition specified in the query's WHERE clause.  Note: The Oracle cost-based optimizer will build the hash table using what it thinks is the smaller of the two tables.  It uses the statistics to determine which is smaller, so out of date statistics could cause the optimizer to make the wrong choice.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>4,125</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>3,397</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>345.008</font></td></tr></table><a name="step19"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep19"><font size=3>19</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step accepts two sets of rows, each from a different table.  A hash table is built using the rows returned by the first child.  Each row returned by the second child is then used to probe the hash table to find row pairs which satisfy a condition specified in the query's WHERE clause.  Note: The Oracle cost-based optimizer will build the hash table using what it thinks is the smaller of the two tables.  It uses the statistics to determine which is smaller, so out of date statistics could cause the optimizer to make the wrong choice.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>4,146</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>3,397</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>364.912</font></td></tr></table><a name="step20"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep20"><font size=3>20</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step accepts two sets of rows, each from a different table.  A hash table is built using the rows returned by the first child.  Each row returned by the second child is then used to probe the hash table to find row pairs which satisfy a condition specified in the query's WHERE clause.  Note: The Oracle cost-based optimizer will build the hash table using what it thinks is the smaller of the two tables.  It uses the statistics to determine which is smaller, so out of date statistics could cause the optimizer to make the wrong choice.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>4,176</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>3,396</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>391.336</font></td></tr></table><a name="step21"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep21"><font size=3>21</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step accepts a row set (its only child) and sorts it in order to identify and eliminate duplicates.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>4,221</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>18</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>2.074</font></td></tr></table><a name="step22"> </a><table cols=5 width=634><tr><td align=center bgColor=#f7f7e7 width=40 vAlign=top>&nbsp;&nbsp;<a href="#planStep22"><font size=3>22</font></a>&nbsp;&nbsp;&nbsp;</td><td align=left bgColor=#f7f7e7 width=384><font size=3>This plan step designates this statement as a SELECT statement.</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=50><font size=3>4,221</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=70><font size=3>18</font></td><td align=right bgColor=#f7f7e7 vAlign=top width=90><font size=3>2.074</font></td></tr></table></HTML>