How to avoid full table scan without where clause.
Hi,
I have a system generated view which is based on our custom table.
The view does "UNION ALL" to our table.
SELECT C.SCHEDULE_ITEM_ID,
SYSDATE,
0,
USERENV ('SESSIONID'),
'C',
NULL,
0,
999912312359591111122222 ROW_KEY,
C.SCHEDULE_ID,
C.LINE_NUMBER,
C.DESCRIPTION,
C.MILESTONE_DATE,
C.MILESTONE_VALUE,
C.MILESTONE_ACHIEVED,
C.GRO_COMMENTS,
C.SUPPORT_DOC_REF,
C.SCO_NUMBER
FROM MILESTONE_SCH_LINES C; --This is our custom table.
So, I am not supposed to modify the view to put a where clause. And its going for full table scan.
Is there any way by which I can avoid full table scan on this table MILESTONE_SCH_LINE ?
Abdul Wahid