Re: FTS on small Materialized View, should I cache it in the KEEP Pool ?
Date: Fri, 6 Jun 2008 13:52:45 +0100
<krislioe_at_gmail.com> wrote in message
> Hi all,
> I have a small MV (1773 rows) that is used in a Query JOIN (the query
> & the explain plan is attached below). Although I already create index
> for the MV, it is always FTS in the query.
> I read a Tuning tips, that FTS on small table should be cached in the
> KEEP POOL, with this command :
> ALTER TABLE ITT.MV_CONVERT_UOM STORAGE (BUFFER_POOL KEEP);
> Should I do this ?
> Thank you for your help,
By the way, you are allowed to create indexes on the tables that sit under materialized views - just don't make them unique indexes
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Author: Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.htmlReceived on Fri Jun 06 2008 - 07:52:45 CDT