The Procedure cannot be run locally.
9.2
Attached is the Execution Plan.
Nothing
yup. Table Anayzed everyday.
No skewed data.
No Materialized views.
Windows.
Rows COST Plan
---------- ----------
1 53 SELECT STATEMENT REMOTE
1 53 SORT GROUP BY
COUNT STOPKEY
1 48 NESTED LOOPS OUTER
1 46 NESTED LOOPS OUTER
1 44 NESTED LOOPS
1 42 NESTED LOOPS OUTER
1 39 NESTED LOOPS
1 36 NESTED LOOPS
1 34 NESTED LOOPS
1 32 NESTED LOOPS OUTER
Rows COST Plan
---------- ----------
1 31 NESTED LOOPS OUTER
1 29 NESTED LOOPS OUTER
1 27 NESTED LOOPS
1 24 NESTED LOOPS OUTER
1 24 NESTED LOOPS OUTER
1 21 NESTED LOOPS OUTER
1 18 NESTED LOOPS
1 15 NESTED LOOPS
1 7 VIEW VW_NSO_1
1 SORT UNIQUE
COUNT STOPKEY
Rows COST Plan
---------- ----------
1 3 TABLE ACCESS BY INDEX ROWID
S_ASSET_RE
1 7 NESTED LOOPS
1 4 TABLE ACCESS BY INDEX
ROWID S_ASSET
1 3 INDEX RANGE SCAN
S_ASSET_EM_UNIVID
1 2 INDEX RANGE SCAN
S_ASSET_REL_F1
1 2 TABLE ACCESS BY INDEX ROWID
S_ASSET
1 1 INDEX UNIQUE SCAN S_ASSET_P1
1 3 TABLE ACCESS BY INDEX ROWID
S_ASSET_MEAS
1 2 INDEX RANGE SCAN
S_ASSET_MEAS_U1
1 3 TABLE ACCESS BY INDEX ROWID
S_ASSET_REL
1 2 INDEX RANGE SCAN S_ASSET_REL_F1
Rows COST Plan
---------- ----------
1 3 TABLE ACCESS BY INDEX ROWID
S_ASSET_REL
1 2 INDEX RANGE SCAN
S_ASSET_REL_EM_PARASSET
1 TABLE ACCESS BY INDEX ROWID
S_ASSET_REL
1 2 INDEX RANGE SCAN
S_ASSET_REL_EM_PARASSET
1 3 TABLE ACCESS BY INDEX ROWID
S_ASSET_REL
1 2 INDEX RANGE SCAN S_ASSET_REL_F1
1 2 TABLE ACCESS BY INDEX ROWID S_ASSET
1 1 INDEX UNIQUE SCAN S_ASSET_P1
1 2 TABLE ACCESS BY INDEX ROWID S_ASSET
1 1 INDEX UNIQUE SCAN S_ASSET_P1
1 1 TABLE ACCESS BY INDEX ROWID S_PROD_INT
Rows COST Plan
---------- ----------
1 INDEX UNIQUE SCAN S_PROD_INT_P1
1 2 TABLE ACCESS BY INDEX ROWID
S_PROD_INT_XM
3 1 INDEX RANGE SCAN S_PROD_INT_XM_U1
1 2 TABLE ACCESS BY INDEX ROWID S_ASSET
1 1 INDEX UNIQUE SCAN S_ASSET_P1
1 3 TABLE ACCESS BY INDEX ROWID S_ASSET_XM
1 2 INDEX RANGE SCAN S_ASSET_XM_EM_PAR_ATTR
1 3 TABLE ACCESS BY INDEX ROWID S_ASSET_ACCNT
1 2 INDEX RANGE SCAN S_ASSET_ACCNT_U1
1 2 TABLE ACCESS BY INDEX ROWID S_ADDR_PER
1 1 INDEX UNIQUE SCAN S_ADDR_PER_P1
Rows COST Plan
---------- ----------
1 2 TABLE ACCESS BY INDEX ROWID S_ORG_EXT
1 1 INDEX UNIQUE SCAN S_ORG_EXT_P1
1 2 TABLE ACCESS BY INDEX ROWID S_ASSET
1 1 INDEX UNIQUE SCAN S_ASSET_P1
Received on Fri May 26 2006 - 16:38:12 CDT
