Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 07 Jan 2005 @ 18:01:34 GMT

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

Subj:   Re: Stats on Volatile table -- Possible??
From:   Michael Larkins

Hello Venkata:

I am curious where you found the reference to collecting statistics on a volatile table in the Unleash the Power book that you referenced. I used the electronic versions of both the second and third editions of the book to do a find on the correct use of the "collect statistics" command and also the incorrect use as "collect temporary statistics" that you referenced. After looking through chapter 18 on collecting statistics and also through chapter 19 which addresses the creation and use of all temporary tables (volatile and global) within Teradata, there are no references to "collect temporary statistics" and none that indicate collecting statistics on a volatile table.

Is it possible you mis-read or mis-quoted the contents of the book?

If not, I would greatly appreciate you pointing me to the page number and edition that contains the erroneous example to which you are referring.

Thanks in advance.

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

  <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: 28 Jun 2020