I have a situation where the tables have more than 500 columns and users have privileges to construct dynamic query using an application.
we need to optimize search in this scenario. I can't create indexes on all columns or even a single index for all columns. also we need to do this with out changing the database schema and application.
View Complete Post