What are the types of tables in Teradata
Answer Posted / rajesh kumar
update on previous answer:
1.Derived table stores the derived result from a subquery.
2.It uses only spool space, so no table definition,
permission needed.
simple query eg:
select * from (select max(sal) from emp) DT (Max_sal)
answer:
derived table(DT) has Max salary and result would be
Max_sal- here subquery result is maintained in derived table
-------
25000
3. derived table auto drops after the query ends
Is This Answer Correct ? | 22 Yes | 0 No |
Post New Answer View All Answers
How many types of joins are there in teradata?
How can we check the version of Teradata that we are using currently?
Highlight the points of differences between the database and user in Teradata.
What are differences between teradata and ansi session modes in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
What is difference between user and database in teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is primary index and secondary index?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is meant by a dispatcher?
Can you fastexport a field, which is primary key by putting equality on that key?
What are the 5 phases in a multiload utility?
How would you load a very large file in teradata in general?
Highlight the differences between Primary Key and Primary Index.