Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 18 May 2010 @ 09:12:16 GMT


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


Subj:   Questions (Modes, SQL Assistant, Indexes)
 
From:   Dmitriy.Boyko

Hi, All!

I have three questions:

1. What is the difference between ANSI SQL and Teradata SQL? I mean does anyone use ANSI Sql and in what cases?

2. How SQL assistant estimates the total number of rows query returns before loading them to client (By default it asks the question if the total number exceeds 20K)?

3. Does anyone use indexes on huge fact tables (different from primary)? What is the size of such indexes (table size (row count)/ index size). What literature about "right" index building can you suggest?

Great thanks!


Best regards,

Dmitriy Boyko



     
  <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