Archives of the TeradataForum
Message Posted: Thu, 18 Dec 2003 @ 20:00:15 GMT
Can any one help me out here to understand the following text in a better way . For example if I have a Table with 1000 rows and unique values on NUSI are 25 . How this is realated to the values below
The guiding principle for using NUSIs is that there should be fewer rows that satisfy the NUSI qualification condition than there are data blocks in the table.
Whether the Optimizer uses a NUSI depends on the percent of rows per NUSI value, as follows:
IF this many rows
< 1 per block NUSI access is faster than full table scan. For example, if there are 100 rows per block and 1 in 1000 rows qualify, the Optimizer reads 1 in every 10 blocks. NUSI access is faster.
>=1 per block full table scan is faster than NUSI access. For example, if there are 100 rows per block and 1% of the data qualifies, the Optimizer reads almost every block. Full table scan may be faster.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|