title: SQL Server don't use specific index
body: <p>I have 2 types of queries. First one needs to take a bunch of rows by groupId and some additonal criteria (several indices are required) and second needs to take a row by id. However, first type of query, uses an index, which doesn't have groupId in it and takes a while.</p>
  
  <p>At the moment I disabled (id, ...) index, but I need to turn it back on at some point.</p>
  
  <p>My indices: </p>
  
  <pre><code>ix1_groupId_id2_id3_ival_iid
  ix2_groupId_id3_id2_ival_iid
  pk_id
  </code></pre>
  
  <p>I want to write something like this:</p>
  
  <pre><code>SELECT id2, COUNT(*)
  FROM table (WITHOUT(INDEX(pk_id))
  WHERE groupId=x
  GROUP BY id2
  </code></pre>
  
  <p>How to tell the SQL Server, that he won't use pk_id index?</p>