Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Tue, 27 Jan 2015 22:43:59 +0300
Message-ID: <CAOVevU5UERF15n_SvbkNFTFHKaRYW186CiX3sqJ_+_Vfgw0-8Q_at_mail.gmail.com>

It seems that "GROUP BY PLACEMENT" trasformation was performed before transitive closure, so transitive closure was not performed after this trasformation.

--

Best regards,
Sayan Malakshinov
Senior performance tuning engineer
PSBank
http://orasql.org

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 27 2015 - 20:43:59 CET