In our environment we have queries with same number of rows retrieval from a particular view ,but difference in the query conditions. We have multiples of these type of queries and they will execute high number of times in a day. As we are using same view for all these queries . Can we reduce the resource consumption and faster retrieval .Is there any way or some suggestion to tune this type of queries.
Thanks in advance.