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
- 10420 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
How many codd's rules are satisfied by teradata database?
How can bottlenecks be identified?
How does hashing happens in teradata?
How do you do backup and recovery in teradata?
Can you connect multiload from ab initio?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is teradata and why it is used?
What are the functions of a teradata dba?
What are tpump utility limitations?
What are the updated features of teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
Explain the new features of teradata?
What are the newly developed features of Teradata?
What is the meaning of Caching in Teradata?
any one answer me how they can analyzing the project using data ware housing?
