@Saurav Kumar (Digital)
Yes, you are right. In SharePoint 2010, if the query uses more than eight columns, the operation is blocked.
However, many limits in SharePoint Server can be changed, and thresholds and supported limits guidelines are determined by performance. In other words, you can exceed the default values of the limits, but as you increase the limit value, farm performance and the effective value of other limits may be affected.
In SharePoint 2010 change List View Lookup Threshold:
1.Go to SharePoint Central Admin
2.Click Manage web apps link
3.Select the web application for which you’re change the lookup limit
4.Click the drop-down arrow beneath “General Settings” >> “Resource Throttling”
5.On the Resource Throttling dialog, edit the list view lookup limit under the List View Lookup Threshold section, and then Save it.
Thanks,
Echo Du
===========
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.