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
- 10272 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 is meant by a Clique?
Why is the case expression used in teradata?
What is the primary index in teradata?
How is MLOAD Teradata Server restarted after execution?
What is meant by a Least Cost Plan?
How you will check the version of teradata?
Explain and compare pros and cons of snow flake schemas?
What is collect statistics?
Steps to create a data model?
Explain the most common data types used in teradata?
What is meant by a node?
Explain some differences between mpp and smp?
What is the difference between teradata and basic rdbms?
What is the purpose of joins in teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
