Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Can we take collect stats on Dervied Tables and Volitable
tables,
What is Golabal Temporary table what is the use of this
Golabal Temporary table ,When we create any kind table in
Teradata it will show in Golabal Temporary table

Answer Posted / jai

We can take collect stats for volatile table for version
6.1.2 onwards Golabal Temporary table is usable for
particular session only the table defination is avaialble
in data dictionary and it takes space temporary

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1086


What is the difference between union and union all in teradata?

1194


What's the difference between timestamp (0) and timestamp (6)?

1257


How to run a query in teradata?

1147


tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

901


What is the purpose of using case expression in teradata?

1068


Explain the parallel data extension in teradata?

1152


What are the primary characteristics of the Teradata.

1238


What is a dimension table?

1104


What is the command in bteq to check for session settings ?

1234


In general, how do you optimze any sql in teradata?

1090


What is teradata? What are some primary characteristics of teradata?

1027


Steps to create a data model?

1182


What are aggregate tables? How do you design them using teradata?

1221


Why do you get spool space errors? How do trouble-shoot them?

1094