Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 20 Mar 2006 @ 22:22:13 GMT


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


Subj:   Performance issue on a huge table..
 
From:   Choksi, Ketan

I have a table xyz :

     CREATE SET TABLE xyz ,NO FALLBACK ,  NO BEFORE JOURNAL,  NO AFTER
     JOURNAL,   CHECKSUM = DEFAULT
          (c1 decimal(15,7)
           c2....
          ....
          ...
           c218)

So there are 218 columns in this table.

Total number of records are 190,000,000

The explain plan for

     select *
       from xyz
       where c1 between 35123456.0101021 and 12384940.0101012

show 4 mins and 07 secs

I have : c1 as the PI (unique) and c2, c3, c4, c5 are NUSI. Stats are colleted on all these indexed columns. Most of the columns are in compressed.

Is there any thing else I can do to tune this table/sql other then partition it ???


Thanks



     
  <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: 27 Dec 2016