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
- 10287 Views
- I also Faced
- E-Mail Answers
Answer Posted / saravanan
If your question is about how Parsing engine would fetch
DEPTID=10, it will undergo a FULL TABLE scan since Dept_Id
is a Non unique secondary index.
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What are the components used in smp and massively parallel processing (mpp) machines?
Explain the meaning of Amp?
How many sessions of MAX is PE capable of handling at a particular time?
What is teradata?
What are the available primary index types?
What are the updated features of teradata?
Explain parsing engine in teradata?
If a Node is busy what are the steps you can take to avoid ?
What are differences between teradata and ansi session modes in teradata?
How do you set the session mode parameters in bteq?
Explain teradata architecture in detail with a diagram.
any one answer me how they can analyzing the project using data ware housing?
What are the available primary index types in teradata.
What is the difference between union and union all in teradata?
What is the purpose of joins in teradata and what are the available join types?
