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
- 8791 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 is bteq utility in teradata?
Which is faster fastload or multiload?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Mention a few of the ETL tools that come under Teradata.
What is a three-tier data warehouse?
What are the joins in teradata?
What is multi insert?
Explain teradata architecture?
What is the difference between union and union all in teradata?
What is the basic syntax for teradata select statement?
What are the advantages of teradata?
How to eliminate product joins in a teradata sql query?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the available primary index types?
How can bottlenecks be identified?
