Re: Tuning SQL

From: Craig Brady <cpbrady_at_frontiernet.net>
Date: 15 Jan 1999 01:33:09 GMT
Message-ID: <77m5sl$q4e$1@node17.cwnet.frontiernet.net>

Susan -
without going into massive detail, the execution is most indented (rightmost) working out to the left in blocks. There's a discussion of this in the Oracle Documentation, the Tuning Manual, Chapter 20, complete with samples.

Hope this helps.

Craig Brady

sgoldberg wrote in message <369E08F9.26AE_at_sou.edu>...
>Hi, I have a query I am trying to fine tune. I am using the plan table
>to try and understand the execution steps. Here is the formatted output
>from the plan table. Can anyone tell me the order of steps that will be
>executed from this output?
>--
>SELECT STATEMENT Cost =
>1 (1) SORT(ORDER BY)
>2 (1) FILTER
>3 (1) NESTED LOOPS
>4 (1) NESTED LOOPS
>5 (1) TABLE ACCESS(BY ROWID) SFRSTCR
>6 (1) INDEX(RANGE SCAN) SFRSTCR_INDEX2
>7 (2) TABLE ACCESS(BY ROWID) STVRSTS
>8 (1) INDEX(UNIQUE SCAN) PK_STVRSTS
>9 (2) INDEX(RANGE SCAN) SPRIDEN_KEY_INDEX
>10 (2) TABLE ACCESS(BY ROWID) TBRACCD
>11 (1) INDEX(RANGE SCAN) PK_TBRACCD
>12 (3) TABLE ACCESS(BY ROWID) TBRACCD
>13 (1) INDEX(RANGE SCAN) TBRACCD_CREDITS_INDEX
>
>Any help will be appreciated.
>
>Susan Goldberg
>Programmer
>Southern Oregon State College
>sgoldberg_at_sou.edu
Received on Thu Jan 14 1999 - 19:33:09 CST