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
- 10214 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
how do you manage the production space. what are the proactive methods you can take ?
What are the available primary index types?
What is logical data model?
What are the string manipulation operators and functions associated with teradata?
In Teradata, what is the significance of UPSERT command?
Can we collect statistics on table level?
what are the day to day activities of teradata DBA ?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Highlight the differences between Primary Key and Primary Index.
What are the updated features of teradata?
In BTEQ, how are the session-mode parameters being set?
What is dimensional modeling?
What are the various indexes in teradata? How to use them?
Why managing the data is important?
Differentiate database data and data warehouse data?
