Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Index help for filter columns
 
From:   Pritam Bagul

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016