What are the types of tables in Teradata
Answer Posted / ravi bandi
permanent tables:
1.set---which thow out any rows that complete duplicates
2.mutiset--which allows multiple instances for same row.
temporary tables:
1.global temporary tables-- when it is created its
definition stored on data dictionary. the data will be
stored on temp space that's why data is active upto the
session ends, we can collect statistics on GTT.
2.volatile temporary tables--when it is created the
definition is stored on cache.the data will be stored in
spool space,thats why data and table defition both are
active up to session ends.you can't collect statistics on
VTT.
3.derived tables-- when we created the definition is stored
on cache.it is local to an sql query.
they are specified on a query level with an AS keyword in
an sql ststment.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the functions involved in shared information architecture?
What is the use of having index on table?
Where is teradata rdbms used?
What do you mean by teradata intellicloud?
What are the main components of teradata system?
What are the design features involved in teradata?
What is teradata? What are some primary characteristics of teradata?
Explain the term 'tables' related to relational database management system?
What is meant by a node?
What are the enhanced features in teradata v2r5 and v2r6?
How do you see a ddl for an existing table?
What is the difference between fastload and multiload? Which one is faster?
What are the various indexes in teradata? How to use them?
What do you mean by fastexport in teradata?
Name the five phases that come under MultiLoad Utility.