SharePoint 2013 List Threshold Issue

Question

I am not able to retrieve list items due to it has crossed threshold limit. The number of items in the list is 150000 and I am trying to fetch certain items filtered by a field value(say 'pincode'). Such matched values are not more than 20; Still, I am getting error of 'Threshold limit'

Please check my steps and let me know if I have done anything wrong.

1. Created SP List.
2. Created columns One of the columns is 'pincode',
3. which I create as Index column (primary index).
4. upload excel list data into sharepoint list using powershell.(around 150000 entries)
5. The written code in javascript to fetch List data filtered by 'pincode' with a particular number (say 110015).

Here is my CAML Query

<Query><Where><Eq><FieldRef Name='pincode' /><Value Type='Number'>110015</Value> </Eq></Where></Query>

Error after operation failed:

"The attempted operation is prohibited because it exceeds list view threshold enforced by the administrator"

It would highly appreciable if someone could give a solution.

Answer 1

Try to set a limit in your fetched data.

<View>
 <Query>      
     YOUR QUERY
 </Query>
  <ViewFields>
        <FieldRef Name='pincode'/>
   </ViewFields>
   <RowLimit>10</RowLimit>
</View>

Answer 2

Go to central admin and increase threshold:

1. Choose your web application and click on ribbon drop down in general settings
2. Choose Resource Throttling.
3. Increase List View Threshold param