Archives of the TeradataForum

Message Posted: Tue, 05 Feb 2008 @ 12:55:10 GMT

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

<-- Anonymously Posted: Tue, 5 Feb 2008 07:41 -->

We have some tables that have concentrated values within the NUPI.

CASE 1: 10M row table; 1M rows with modal value Normal_Tuesday

CASE 2: 10M row table; 100K rows with modal value FAT_Tuesday

CASE 3: 10M row table; 10K rows with modal value Super_Tuesday

CASE 4; 10M row table; 1k have the with modal value Tuesday

Row lengths are 125 bytes, blocking is at 128K, so ~1000 rows per block.

What is the performance impact on loads in the cases?

What is the performance impact on queries that target the modal value?

What is the performance hit on table scans with residual conditions involving joins on the PI to another table with

a) same PI

b) different PI

Thank-you for your help.

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