2 Replies Latest reply on Sep 21, 2015 2:46 PM by 2837336

    Full Table Scan

    2837336

      Hi Guys,


      I have a a view with the below logic:

       

      SELECT

            , 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.

      SELECT *

      FROM SQLSRV.Subscription_vw_ver_2_test

      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.


      Regards,

      Pavan