Archives of the TeradataForum

Message Posted: Wed, 13 May 2009 @ 09:33:22 GMT

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

If you add a PPI to a table with NUSI's, you may encounter situations where the optimizer chooses to use the PPI instead of the NUSI, when in fact NUSI access would be faster.

If memory serves me, there are some internal DBS control flags that can be used to help manage such situations.

Thanks.

Dirk Anderson
Architect
Enterprise Information Management

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