Archives of the TeradataForum
Message Posted: Mon, 29 Mar 2004 @ 19:18:27 GMT
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!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|