Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ordered_hint
It depends how often the data is updated and how often the query runs.
In a similar situation for me, DB is updated once a day, lots of queries during the day a materialzed view helped.
Create a materliazed view on top without changing anything on the query and update this MV in sensitive intervalls. When it's stale it will pick above query when not it will do a full scan on the MV with only two colums, instead of t1 (some columns) and than a hash join with a view with maybe lots of columns and maybe lots of joins. Received on Wed Sep 21 2005 - 17:48:41 CDT