Takeaways from Threshold limits of Sharepoint Lists

Few takeaways of Sharepoint Lists with large size.

• If the data crossed the threshold value, applying filters on multiple indexed columns won’t display records. 
• The first filter should be the Indexed column and only one indexed column should be used in a filter criteria
• We cant index a column which has multi select enabled.
• Threshold will not effect the performance of an individual item access.
• If list crosses view threshold, we can't use it as lookup reference in any other list. 

Also, its better not to apply many permission restrictions  as it checks for individual permission set while fetching a record, which may impact performance.

For reference, use below links.

https://support.office.com/en-us/article/Manage-large-lists-and-libraries-in-SharePoint-b8588dae-9387-48c2-9248-c24122f07c59

https://support.office.com/en-us/article/Manage-lists-and-libraries-with-many-items-fba0c8b7-79bb-4ea4-9aff-bf145a689e8e