Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 05 Aug 2004 @ 19:49:11 GMT

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

Subj:   Re: Cylinder Read vs MAXBLOCKSIZE
From:   Maxwell, Donald

Very interested in the answer to this question, and I also have a followup question.

If the block size is less relevant with cylinder read enabled, does this mean I can use smaller block sizes to allow the NUSI's to be used more often, without affecting full table scan times? For example, if I cut the block size in half, I presume I can select twice as many rows using the NUSI and with cylinder read enabled, I presume my full table scan times will be unaffected.

Is this correct?


  <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