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