title: SharePoint 2010 Expand recurrences CAML Query exceeding list view threshold
body: <p>Trying to get event items from a list, I issue a CAML query that only returns a small number of items (about 17). When I set the List View Threshold at 10000 everything works fine, but when I set the LVT at 5000, I get a "Exceeded List View Threshold set by the administrator" error.
  My CAML query is pretty simple:</p>
  
  <pre><code>&lt;Where&gt;
  &lt;And&gt;
      &lt;DateRangesOverlap&gt;
          &lt;FieldRef Name="EventDate" /&gt;
          &lt;FieldRef Name="EndDate" /&gt;
          &lt;FieldRef Name="RecurrenceID" /&gt;
          &lt;Value Type="DateTime"&gt;
              &lt;Now /&gt;
          &lt;/Value&gt;
      &lt;/DateRangesOverlap&gt;
      &lt;And&gt;
          &lt;BeginsWith&gt;
              &lt;FieldRef Name="Place" /&gt;
              &lt;Value Type="Text"&gt;Boston&lt;/Value&gt;
          &lt;/BeginsWith&gt;
          &lt;Or&gt;
              &lt;Eq&gt;
                  &lt;FieldRef Name="Status" /&gt;
                  &lt;Value Type="Text"&gt;Status1&lt;/Value&gt;
              &lt;/Eq&gt;
              &lt;Eq&gt;
                  &lt;FieldRef Name="Status" /&gt;
                  &lt;Value Type="Text"&gt;Status2&lt;/Value&gt;
              &lt;/Eq&gt;
          &lt;/Or&gt;
      &lt;/And&gt;
  &lt;/And&gt;
  </code></pre>
  
  <p></p>
  
  <p>Can anyone explain why this may be happening? Is is because when expanding recurrences SP actually runs a separate query that result in the LVT being exceeded? Any suggestions to restructure the query would be great, but I do need to look at all occurrences of recurring events (not just the master items).</p>