title: Optimize query by looking at query plan
body: <p>optimize Sqlserver 2005 query by query plan</p>
  
  <p>I have a following query which takes 1.7 seconds to pull 72 records can take more time if more items available.</p>
  
  <p>When i run query plan i found expensive operation is "ReviewCompleteFlag =0 AND ReviewItemDeleteFlag = 0 AND ActivationDateTime" b/c non of them having index</p>
  
  <pre><code>ReviewCompleteFlag value can be 0 or 1
  ReviewItemDeleteFlag values can be 0 or 1
  itemid is foreign key
  </code></pre>
  
  <p>is there a way i can optimize this query ?</p>
  
  <pre><code>SELECT
  
        TOP 200000
  
      ItemId
      FROM
      ItemReview (nolock)
      WHERE ReviewCompleteFlag =0 AND ReviewItemDeleteFlag = 0 AND ActivationDateTime is null
      ORDER BY ReviewPriority DESC
  </code></pre>