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
- 10274 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 updated features of teradata?
What is dimensional modeling?
Explain vproc in teradata?
What are the various reporting tools in the market?
Highlight all the modes that are present under Confidence Level.
Can you connect multiload from ab initio?
What tools would you use for that?
What are the functions of a Parser?
What are different table types used in teradata?
What is the command in bteq to check for session settings ?
What is the purpose of joins in teradata?
List out teradata data types?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How can bottlenecks be identified?
What is bteq utility in teradata?
