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

yes we camn collect statistics on globaltemporary table
wher as we cant on derived and volatile because these table
will be created under spool mempory.and global tempoary
tables will be created to get the intemediate results this
table will be created and dropped as part of the query.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oltp?

986


Why managing the data is important?

1024


How is MLOAD Teradata Server restarted after execution?

1279


How to view every column and the columns contained in indexes in teradata?

1062


What are the functions involved in shared information architecture?

1084


How to find duplicates in a table?

1231


What do you mean by teradata intelliflex?

1120


Comment whether bottleneck is an error or not.

1171


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2180


Different phases of multiload?

1028


Highlight a few of the advantages that ETL tools have over Teradata.

1100


how many modules are there in telecome domain?how to explain the architecture?

2029


What is the purpose of using case expression in teradata?

1028


What are default access rights in teradata? What explicit right can be given to a user?

1120


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2876