plz explain parlla distribution and subtable concept in teradata

Answer Posted / tdguy

Parallel distribution - Due to "shared nothing"
architecture, TD distributes and fetches the data in
parallel. Mainly because of AMP,PE and BYNET.
Subtables - These are created and used by TD, when the
secondary indexes come into picture.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between teradata and oracle?

558


What are the different softwares used with their functions in teradata?

576


What is node? How many nodes and amps used in your previous project?

673


what is object level locking ? where do appear this type of locking ?

3113


List out teradata data types?

559






Describe the set operators in teradata.

583


if collect stats but it show low confidence why?

1190


What are the functions of a Parser?

610


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

537


What happens in a conflict? How do you handle that?

622


What are the main components of teradata system?

584


What is TPD?

907


What is the purpose of joins in teradata and what are the available join types?

547


how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1280


what is sysdba and sysdbc ? which has high priority ?

3372