hpuxrac wrote:
> DA Morgan wrote:
>> hpuxrac wrote:
>>> John wrote:
>>>> Hi,
>>>>
>>>> Can anyone tell me what
>>>> TABLE ACCESS (BY USER ROWID)
>>>> means? Thanks!
>>>>
>>>> 0 SELECT STATEMENT Optimizer=RULE
>>>> 1 0 SORT (AGGREGATE)
>>>> 2 1 NESTED LOOPS
>>>> 3 2 TABLE ACCESS (FULL) OF 'TBRACCD'
>>>> 4 2 TABLE ACCESS (BY INDEX ROWID) OF 'TBBDETC'
>>>> 5 4 INDEX (UNIQUE SCAN) OF 'PK_TBBDETC' (UNIQUE)
>>>> 6 0 NESTED LOOPS (OUTER)
>>>> 7 6 NESTED LOOPS
>>>> 8 7 NESTED LOOPS
>>>> 9 8 NESTED LOOPS
>>>> 10 9 TABLE ACCESS (BY INDEX ROWID) OF 'TBRACCD'
>>>> 11 10 INDEX (RANGE SCAN) OF 'TBRACCD_CREDITS_INDEX' (N
>>>> ON-UNIQUE)
>>>> 12 9 TABLE ACCESS (BY INDEX ROWID) OF 'TBBDETC'
>>>> 13 12 INDEX (UNIQUE SCAN) OF 'PK_TBBDETC' (UNIQUE)
>>>> 14 8 TABLE ACCESS (BY INDEX ROWID) OF 'SPRIDEN'
>>>> 15 14 INDEX (RANGE SCAN) OF 'SPRIDEN_KEY_INDEX' (UNIQUE)
>>>> 16 7 INDEX (RANGE SCAN) OF 'SPRIDEN_KEY_INDEX' (UNIQUE)
>>>> 17 6 TABLE ACCESS (BY USER ROWID) OF 'SPRADDR'
>>>>
>>>>
>>>> John
>>> Why don't you give us a complete SQL statement and include some details
>>> about your environment ( oracle release etc )?
>>>
>>> Even a better idea, maybe you should start a new thread with your
>>> question instead of adding it to an existing ( old and apparently
>>> unrelated ) thread.
>> John was on-topic and, as I presume you knew the answer, you could
>> have in fewer words helped him as did Jeroen.
>
> Actually John top posted and included only a copy and paste of
> information from the original item submitted in the top part of his
> reply. It was not exactly clear to me from that information that he
> was continuing with a related question.
>
> Retrieving by ROWID and having a PLSQL function involved is not exactly
> standard practice at my shop. Oracle has changed the verbiage slightly
> in the explain plan for those kind of actions and I was looking for
> more complete information.
>
> I find that a better idea than going off on tangents with incomplete
> information and still recommend that approach to others.
All that aside ... wouldn't it have been better to help the OP rather
than criticize someone else? And, as you've seen, no one went off-topic
with the possible exception of yourself.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Nov 21 2006 - 10:17:05 CST
