| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Improving the speed of the below query
The true problem was a VIEW breaking all the rules. It contained aggregate functions which causes the view not to be materialized.
I created a Materialized View for OTV and the query response went from 15 minutes to 10 seconds!
Its a DSS environment! Received on Wed Feb 21 2001 - 16:35:50 CST
 |
 |