Materialized view option (suggestion) [message #637715] |
Fri, 22 May 2015 03:34 |
hitesh.bhatt
Messages: 84 Registered: February 2014 Location: INDIA
|
Member |
|
|
Hi,
In my production environment, one of the query takes only 20 seconds to complete.
But the number of execution are very large around 5000 executions per day, because of which it always appears in AWR top SQL scripts.
So, can I suggest application team to create M-VIEWS so that they can directly fetch M-Views instead of tables every time ?
Please correct me if I am wrong.
Many thanks in advance.
|
|
|
|
|
|
|
|