Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 05 May 2008 @ 12:03:48 GMT


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


Subj:   Re: Regarding the I/O count
 
From:   McCall, Glenn David

This is one of those "you need to supply a bit more information" things.

With the (non) information you have provided there are really only 2 (generic) options to reduce the I/O count:

1) Tune the query/environment so that your query runs more *efficiently*.

2) Delete some data from the table.


The options for tuning a query and/or its environment are extensive. The options you would employ will vary depending upon the individual circumstances of the query you are trying to make go faster.

There is probably a 3rd option - which isn't so much about reducing the I/O count. You could upgrade and distribute the workload over more nodes. This assumes you don't have a hot AMP situation which puts you squarely in option 1 territory.


Regards

Glenn Mc



     
  <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