you" ) is not getting used - its presence or ..." />
Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 22 Nov 2011 @ 17:22:39 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Dropping Ix: Impact on performance
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, November 22, 2011 08:32 -->

Hi Sivaji

Yes NUSI 's and their impact on DML as well as compatibility with Load Utils , is well known and you are right about that angle. I was just trying to ascertain my understanding ,that ,if that some Ix out there ( maybe already lying around created by "<> you" ) is not getting used - its presence or absence should be regardless on the SQL you want run. This is just what I thought, but I asked , esp. in Context of T Ix Wiz asking me to drop a NUSI Ix that was not getting used.

Thank you, all

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