Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Tue, 27 Jan 2015 18:44:44 +0300
Message-ID: <CAOVevU5SAv59w1k2OeEda3=Wb98Z0Abv_m4bwMxG--OUadrTpw_at_mail.gmail.com>
:) I may be wrong, but it's because my intuition suggests that hash join 80046 rows from COWS_TCUE_STS_SCHEDULE with 24M rows from COWS_TCUE_STP_PROG_IDX01
and hash join 680K rows with 10M rows from COWS_PURPLE_PART have to produce not too much rows than greatest number of rows from related rowsource.
Date: Tue, 27 Jan 2015 18:44:44 +0300
Message-ID: <CAOVevU5SAv59w1k2OeEda3=Wb98Z0Abv_m4bwMxG--OUadrTpw_at_mail.gmail.com>
:) I may be wrong, but it's because my intuition suggests that hash join 80046 rows from COWS_TCUE_STS_SCHEDULE with 24M rows from COWS_TCUE_STP_PROG_IDX01
and hash join 680K rows with 10M rows from COWS_PURPLE_PART have to produce not too much rows than greatest number of rows from related rowsource.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 27 2015 - 16:44:44 CET