I need to create a list that will have more than 5000 items, in my plan I make more than one view to solve the throttling imitation.
but I'm wondering about item add and edit actions, should I consider anything for these action on my plan.
as example if I have a unique field within the list, technically this mean SharePoint will go to DB and select all items to check if there is same id or not. is this correct? then is there any recommendation to avoid throttling when add and edit items?
Should I add unique fields to indexes?