title: How can I force a view to use a specific index?
body: <p>How can I force a view to use a specific index?</p>
  
  <p>I am getting the below warning message when I try to force use index :</p>
  
  <blockquote>
    <p>Warning: Index hints supplied for view 'BANK.CUSTOMER_ORDER_VIEW' will be ignored.</p>
  </blockquote>
  
  <p>Below is my query:</p>
  
  <pre><code>DECLARE  @VALUE_DATE_START DATE = '20181001',
           @VALUE_DATE_END DATE  = '20181025'
  
  SELECT * 
  FROM BANK.CUSTOMER_ORDER_VIEW WITH(INDEX(IX_ValueDate))
  WHERE VALUE_DATE BETWEEN @VALUE_DATE_START AND @VALUE_DATE_END
  </code></pre>
  
  <p><code>IX_ValueDate</code> is the index of a table that is used in <code>BANK.CUSTOMER_ORDER_VIEW</code>.</p>