Re: CBC latch contention on index root block

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Sat, 19 Jan 2013 03:37:43 +0400
Message-ID: <CAOVevU7_1VeAhMkcpqEXZ60PO+vEM-Og-if1Y=ZZqOSK_rcVGg_at_mail.gmail.com>

Sorry my mistake: not 0, but 871 rows matches to predicates

On Sat, Jan 19, 2013 at 3:33 AM, Sayan Malakshinov <xt.and.r_at_gmail.com> wrote:
> Since there are 891 rows in main table(TAMRABS_PGM) and 133 rows in
> subject(TAMRCUST_GLB_MAP) and 0 rows matches to predicates, may be
> will be better to do at first "hash join outer" with this table?

-- 
Best regards,
Sayan Malakshinov
Senior performance tuning engineer
--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jan 19 2013 - 00:37:43 CET