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
- 10093 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
Syntax for case when statement?
What is spool space? Why do you get spool space errors?
List out all forms of LOCKS that are available in Teradata.
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Define views in teradata with general syntax.
What is the difference between union and union all in teradata?
What happens when a node suffers a downfall?
What is the use of virtual processor connectivity in teradata?
What is meant by a Least Cost Plan?
What is logical data model?
How do you do backup and recovery in teradata?
What are the functions performed by bynet?
What are types of partition primary index (ppi) in teradata?
What are differences between teradata and ansi session modes in teradata?
Explain teradata vs. Redshift?
