Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 26 Mar 2004 @ 18:29:08 GMT

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

Subj:   Re: Aggregate Join Index & Fallback
From:   Ballinger, Carrie

I haven't tested this condition either, but I checked in the Database Design manual V2R5.1 (page 12-6) and the text does suggest that a join index with fallback WOULD be used if an AMP is down.

"If you do not define fallback for a join index and an AMP is down, then the following additional criteria become critical:

1. The join index cannot be used by the Optimizer to solve any queries that it covers

2. The base tables on which the join index is defined cannot be updated."

If the join index is being used for partial covering (which results in joining back to the base table rows) the optimizer would not be able to use the JI if the base table was not also fallback protected, but it sounds like a JI that covers the query completely would be used.

Thanks, --Carrie

  <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