Dear Experts,
We have a complex view fetching data from multiple tables, when we execute the view with certain parameters , It takes a very long
time to fetch the data (10 to 15 minutes). However duing non Business hours like late in the evening,
when we search using the same parameters the data is retreived very fast by the view (less than 1 minute)
We have looked at all possible ways to tune the query, however due to the complex business logic we can not modifiy or redesing the view any further.
Also the expecation is to show real time data so we can not use a materialzed view.
Is this related to database configuration like cache\buffer\main memory or network\infrastructure issue.
Can you please provide any pointers\suggestions to resolve for this problem.
Thanks,
Neeraj.