Archives of the TeradataForum
Message Posted: Tue, 18 Dec 2012 @ 09:43:24 GMT
<-- Anonymously Posted: Tuesday, December 18, 2012 04:29 -->
I have a table with many advanced [around more than 400] empty paritions on DATE_fld column. But when i give the condition 'DATE_fld >DATE' [current date], its obvious it will scan all post partitions after the date given. [My PPI is on DAY basis]
But is there any performance issues when the query scans a lots of empty partitions ?
I know that it might sometimes will mislead for making suboptimal plan choices. But still want other thoughts...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|