Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 10 May 2004 @ 18:04:20 GMT


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


Subj:   Help on Join Indexes
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, May 10, 2004 13:01 -->

Hi,

I have a table with 250 million rows, and Im using ReportNet to display the output. It takes ages to display. So someone told me to use JOIN INDEX . Actually I dont know much about this subject. So could any one educate me on this subject :

a. Documents on Join Index

b. Advantages

c. Does it physically occupy space

d. How does it get refreshed

e. Can I partition


TIA



     
  <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: 15 Jun 2023