Interested to Buy Any Domain ? << Click Here >> for more details...
I have a table with emp id, emp name, dept id and sal where
dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any
one explain how it will fetch the record.
- 4 Answers
- 10411 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajain
Whenever NUSI is created, subtable will be created for each AMP's with the fields rowid and secondary index value.For NUSI ,subtable will be AMP local ie it will be having the records which are specific to the particular AMP.
When someone queries with the NUSI, all the AMPs will search in their own subtable for particular secondary index .For AMPs which found the particular record in their subtable ,it will retrieve the actual data from the AMP and PE will be consolidating the records and give to user
Since NUSI involves all AMP operation , PE will be deciding whether FULL table scan or ALL AMP operation will be more efficient .
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the different functions included in the server software?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is meant by a dispatcher?
What happens when a node suffers a downfall?
What do you mean by teradata intelliflex?
how many modules are there in telecome domain?how to explain the architecture?
List out teradata data types?
Write a program to show the parser component used in teradata?
What is real time and near real time data warehousing?
Explain the term 'database' related to relational database management system?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What can be achieved by using the teradata rdbms?
What are the various reporting tools in the market?
What are the multiload utility limitations?
If a Node is busy what are the steps you can take to avoid ?
