Archives of the TeradataForum
Message Posted: Tue, 18 May 2010 @ 09:12:16 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|