I'm working on a project with big tables (10 millions records) on MS SQL server and we need to query that table with very complex filters (that span 10+columns) and sort the result on different fields depending on the user selection on the UI.I'm working on a project with big tables (10 mi