Performance - EBS (MOSC)

MOSC Banner

Row Source Operation VS Execution Plan

edited Sep 24, 2012 12:25AM in Performance - EBS (MOSC) 5 commentsAnswered
I traced one concurrent program that was showing FTS for a table although columns in WHERE clause were already indexed.

In the trace I found a strange thing


Rows     Row Source Operation
-------  ---------------------------------------------------
      0  TABLE ACCESS FULL RA_CUSTOMER_TRX_LINES_ALL (cr=0 pr=0 pw=0 time=0 us cost=76815 size=30 card=2)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   MODE: ALL_ROWS
      0   TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF 'RA_CUSTOMER_TRX_LINES_ALL' (TABLE)
      0    INDEX   MODE: ANALYZED (RANGE SCAN) OF 'XXRA_CUST_TRX_LINES' (INDEX)


Query:

SELECT
RCTLA.QUANTITY_ORDERED - NVL(RCTLA.QUANTITY_INVOICED,0)   
FROM
APPS.RA_CUSTOMER_TRX_LINES_ALL RCTLA 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center