Archives of the TeradataForum

Message Posted: Fri, 05 Sep 2008 @ 10:05:14 GMT

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

Hi,

I have a table with 1.5 Million records. The table has 1 UPI and 1 NUPI.

Users would query on the table and may filter records based on values to 10 other columns.

My query is for faster record retrieval on user queries what type of indexes I should add?

Will the following help

1. Collect staistics on each of the 10 different columns.

2. Creating 10 NUSI's on these individual columns.

Please suggest if a better approach can be faster? Can I use NUPI on these columns?

Regards

Pritam

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