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

Donald,

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!

Victor


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

Attachments

Library

Quick Reference