We can filter the data using the command "SET Filter " but it slow down the process when your data becomes volume. its has been solved using filtered index but the problem, is when your requirements in filtering your data is interactive or must be a variable you cannot do this in filtered index since it is fix. Is there any other way to cater that requirements.?