title: sharepoint list caml query issue because it exceeds threshold limit
body: <p>I am getting below error while querying SharePoint list,list has 5005 records and threshold limit is 5000.
  I have a sharepoint list having different folders and i am using CAML query with RecursiveAll to get records from all folders. 
  I am getting this error :-</p>
  
  <blockquote>
    <p>The attempted operation is prohibited because it exceeds the list view
    threshold enforced by the administrator. at
    Microsoft.SharePoint.Client.ClientRequest.ProcessResponseStream(Stream
    responseStream) at
    Microsoft.SharePoint.Client.ClientRequest.ProcessResponse() at</p>
  </blockquote>
  
  <p>My query is </p>
  
  <pre><code>"&lt;View Scope='RecursiveAll'&gt; &lt;RowLimit&gt;1000&lt;/RowLimit&gt;&lt;Query&gt;&lt;Where&gt;&lt;Eq&gt;&lt;FieldRef Name='Year' /&gt;&lt;Value Type='Text'&gt;" + Period + "&lt;/Value&gt;&lt;/Eq&gt;&lt;/Where&gt;&lt;/Query&gt;&lt;/View&gt;";
  </code></pre>
  
  <p>Year is indexed column.If i remove where clause,it starts working.It seems to me <code>recursiveall</code> is not working with <code>where</code> clause.</p>
  
  <p><strong>I don't want to change list threshold limit.</strong></p>