Re: Table Access By Index Rowid
- From: jaysingh1@xxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 13 Aug 2004 13:04:48 -0400
Wolfgang,
Sorry about the incomplete info. Kindly look at the complete information
enclosed here.
SELECT * FROM (
SELECT /*+ FIRST_ROWS */ e.userstatusid,
P.processed_by,
P.last_name,
P.first_name,
P.company_name,
c.countryname,
e.customerid,
TO_CHAR(e.LASTUPDATEDATE,'dd MON, yy ')||'AT
'||TO_CHAR(e.LASTUPDATEDATE,'hh24:mi ')||'GMT' formattedlastupdatedate,
P.userid,
business_country_id
FROM (SELECT * FROM PROFILEDUSER WHERE hsbc_user_category IN
('GCAT','HCAT')) P,
(SELECT customerid,userstatusid,profileduserid,lastupdatedate FROM
EXTENDEDATTRIBUTES WHERE lastupdatedate >= SYSDATE-30) e,
COUNTRIES c
WHERE P.profileduserid= e.profileduserid
AND P.business_country_id = c.countryabbrev
AND p.processed_by in ('3')
and p.region in ('4051')
and p.business_country_id='GB'
and e.userstatusid in (1,113)
ORDER BY e.LASTUPDATEDATE desc
)
WHERE ROWNUM <=20
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.04 0.03 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 3.72 14.95 1948 5259 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 3.76 14.98 1948 5259 0 0
Misses in library cache during parse: 1
Optimizer goal: FIRST_ROWS
Parsing user id: 180
Rows Row Source Operation
------- ---------------------------------------------------
0 COUNT STOPKEY
0 VIEW
0 MERGE JOIN CARTESIAN
1 NESTED LOOPS
833 TABLE ACCESS BY INDEX ROWID EXTENDEDATTRIBUTES
2838 INDEX RANGE SCAN DESCENDING (object id 1174163)
832 TABLE ACCESS BY INDEX ROWID PROFILEDUSER
1664 INDEX UNIQUE SCAN (object id 5840)
0 SORT JOIN
0 TABLE ACCESS BY INDEX ROWID COUNTRIES
0 INDEX RANGE SCAN (object id 1131957)
----- Original Message -----
From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
Date: Friday, August 13, 2004 12:29 pm
Subject: Re: Table Access By Index Rowid
> At 09:04 AM 8/13/2004, you wrote:
> > Hi All,
> >
> >I have a question reg. "Table Access By Index Rowid"
> >This is part of my explain plan from tkprof output.
>
> This is part of my answer: Without enough information
>
>
> Regards
>
> Wolfgang Breitling
> Centrex Consulting Corporation
> www.centrexcc.com
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
