This content has been marked as final. Show 2 replies
I have a a view with the below logic:
, T2.CODE AS CODE
, T1.PRODUCT AS PRODUCT
FROM STORE.SY_DATES D
LEFT JOIN SUBSCRIPTIONSALES_VER_2_test T1
ON D.SY_DATE = T1.POSTING_DATE
I am querying from view using the below query. Even though I pass a specific date, the query is doing a full scan.
WHERE POSTING_DATE BEtween to_date('2015-09-13', 'yyyy-mm-dd') and to_date('2015-09-14', 'yyyy-mm-dd');
Even though I pass a specific date, the query is doing a full scan.
Am I missing anything in the view logic?
Any help is appreciated.