Re: getting in a little over my head

> In the second plan
> you do the work of accessing the pol_policy table twice for each row in the
> materialized view rather than once per row

That should have been "for each row selected from" And the doubling only occurs for one of the two link_types.

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

• Original Message ----- From: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> To: "Oracle L" <oracle-l_at_freelists.org> Sent: Friday, September 09, 2011 8:27 AM Subject: Re: getting in a little over my head

Tim's given you an argument for the second plan looking better, here's an argument for the first looking better: In the second plan you do the work of accessing the pol_policy table twice for each row in the materialized view rather than once per row - the work done in the subqueries may be the largest resource user. (And that may also be the case in the original query - so adding the account_id to the quote index and both the account_id and logid to the policy index may be the best way to improve performance.)

--
http://www.freelists.org/webpage/oracle-l