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

From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
To: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
Date: Tue, 27 Jan 2015 22:43:59 +0300

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

References:
- Large Dataset - Estimated 87TB needed for TEMP - suggestions?
  - From: Chris Taylor
- Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?
  - From: Mladen Gogala
- Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?
  - From: Chris Taylor
- RE: Large Dataset - Estimated 87TB needed for TEMP - suggestions?
  - From: Mark W. Farnham
- Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?
  - From: Chris Taylor

Other related posts:

» Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Chris Taylor
» Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Laimutis . Nedzinskas
» Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Chris Taylor
» Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Chris Taylor
» Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Sayan Sergeevich Malakshinov
» Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Chris Taylor
» Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Sayan Sergeevich Malakshinov
» Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Chris Taylor
» Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Chris Taylor
» Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Sayan Malakshinov
» Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Mladen Gogala
» RE: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Mark W. Farnham
» Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Chris Taylor
» RE: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Mark W. Farnham
» Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Chris Taylor
» Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Chris Taylor
» Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions? - Sayan Malakshinov
» Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Mladen Gogala
» Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?- Sidney Chen