Archives of the TeradataForum

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

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

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>>