Why table ACCESS BY INDEX ROWID is slow
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