Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 29 Mar 2004 @ 19:18:27 GMT

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

Subj:   Re: Aggregate Join Index & Fallback
From:   Victor Sokovin


  Well, I have managed to coerce my DBA into giving me an amp-down condition later this afternoon so I can test my aggregate join index with fallback. I expect to have a window of just a few minutes to perform my testing, but I thought I would extend the invitation to any interested parties in this thread - is there any additional test that would prove useful/interesting? Try to keep it simple, and easy to test in under ten minutes.  

Just read your message - hope it's not too late to add my request. If you don't do it already, could you create three identical tables with the same JI and three different combinations of fallback protection:

table fallback: Yes and JI fallback: Yes;

table fallback: Yes and JI fallback: No;

table fallback: No and JI fallback Yes (that's your original case).

If you can do it in 10 min, I'd be interested in the behavior of simple SELECT (preferrably also one which is supposed to be covered by the JI to see whether EXPLAIN still uses the index), INSERT, DELETE and UPDATE.

Many thanks in advance and good luck with the test!


  <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: 23 Jun 2019