Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 19 Nov 2009 @ 15:20:30 GMT

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

Subj:   Re: Partition elimination with CAST INTEGER AS DATE
From:   Anomy Anom

<-- Anonymously Posted: Thursday, November 19, 2009 10:16 -->

Did you COLLECT STATS on system-generated "column" PARTITION? If not, range expressions often tend to scan all partitions.

  <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: 23 Jun 2019