Re: Query cache
Posted by:
Toa Sty
Date: October 31, 2006 04:12PM
Hi Markus,
Yes. Any changes to any table that the cached query uses will invalidate/remove the query from the cache.
So, a good strategy if you need it (it's a workaround really) is to put your frequently changing columns in one table and your less frequently changing but often queried columns in another. (i.e. vertical partitioning)
Toasty
-----------------------------------------
email: 'toasty'*3 at gmail
Subject
Views
Written By
Posted
2864
October 31, 2006 01:32PM
Re: Query cache
2052
October 31, 2006 04:12PM
1995
November 01, 2006 06:27AM
2033
November 01, 2006 12:25PM
2121
November 02, 2006 03:11AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.