Archives of the TeradataForum

Message Posted: Wed, 30 Jun 2010 @ 09:10:45 GMT

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

Hi,

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?

Please help.

Thanks & Regards

Rishi Agarwal

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