Archives of the TeradataForum
Message Posted: Fri, 05 Sep 2008 @ 10:05:14 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|