Archives of the TeradataForum
Message Posted: Wed, 30 Jun 2010 @ 09:10:45 GMT
I have created MLPPI on two columns in a big table. First columns is a date column and second is area_code having 20 distinct values (1,2,3..)
I want to know that -
1. Do I need to use both MLPPI columns in my query in order to make use of PPI or partition will be used even if the first DATE column is used in the filter condition?
2. How can I find out from explain plan how many partitions are being used. When I am using DATE only as a filter condition, explain plan shows partitions as double the number of DATES used ("2 partitions", 4 partitions..). When DATE is used along with AREA_CODE (single or multiple), it says as many partitions as many DATEs. Does that mean that partitions are not used when only single column is used?
Thanks & Regards
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|