Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 22 Nov 2011 @ 08:28:06 GMT

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

Subj:   Re: Dropping Ix: Impact on performance
From:   sivaji.gv

You can check DBQLOBJ (ObjectType='IDX') to see whether other reports are using this index or not.

Dropping the index may not have perf improvement for your sql, however it will have positive impact on the DML operations (insert/update/delete) as it doesnot need to work in keeping NUSI subtable up-to-date.


Sivaji GV

  <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: 15 Jun 2023