One of my list pages in application has anywhere between 12 and 15 filters. All the columns sortable.
I have created a covering index, but it will not be sufficient to handle all the filters and the sortable columns.
What do you suggest create multiple index that covers most of the scenarios or as many indexes.
Thanks
Prince