Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Index help for filter columns
From:   Pritam Bagul


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?



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023