SQL Performance (MOSC)

MOSC Banner

Why table ACCESS BY INDEX ROWID is slow

edited Jul 24, 2015 10:02AM in SQL Performance (MOSC) 3 commentsAnswered

Hi Gurus ,

please help me know why table access by index rowid are slow

SELECT Rec1.rootId  FROM

byrlive19.ReceiptTab Rec1, byrlive19.ApprovableTab App2,

byrlive19.ReceiptCoreApprovableTab Rec3  WHERE Rec3.rootId =

Rec1.rootId AND App2.rootId = Rec1.rootId AND (Rec1.rootId LIKE :a )

AND (App2.ap_ApprovedState = :b AND Rec3.recCA_ProcessedState = :c AND

Rec3.recCA_FirstApproval = :d AND App2.ap_StatusString = :e AND

((Rec1.recR_DueDate >= TO_DATE(:f, 'YYYY-MM-DD HH24:MI:SS') AND Rec1.recR_DueDate < TO_DATE(:g, 'YYYY-MM-DD HH24:MI:SS')  ) OR

(App2.AP_CREATEDATE >= TO_DATE(:h, 'YYYY-MM-DD HH24:MI:SS')   AND App2.AP_CREATEDATE < TO_DATE(:i, 'YYYY-MM-DD HH24:MI:SS') AND

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center