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
- 10092 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
Can you fastexport a field, which is primary key by putting equality on that key?
Explain the meaning of Amp?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is teradata and why it is used?
What do you mean by parsing?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Where is teradata rdbms used?
Write a program to show the parser component used in teradata?
What are default access rights in teradata?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What is a three-tier data warehouse?
What are the various reporting tools in the market?
How to select first n records in teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What is meant by a Highest Cost Plan?
