Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 06 Feb 2004 @ 17:49:18 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: A weird and unusual circumstance...
From:   Victor Sokovin

Did you try SAMPLE RANDOMIZED ALLOCATION instead of just SAMPLE in Query #1? If you have a chance to test it and see that both queries behave in the same way (explain, run time) then the conjecture would be that the optimizer chooses to change the default proportional allocation to randomized. Don't want to speculate further without more details. Perhaps somebody from NCR could enlighten us if they saw something similar before.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016