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
- 10280 Views
- I also Faced
- E-Mail Answers
Answer Posted / saravanan
If COLLECT STATS has been defined on the table EMP, then PE
will avoid going for a FULL TABLE SCAN.
If not, PE will undergo a FULL TABLE SCAN to fetch
DEPTID=100
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Explain and compare pros and cons of start schemas?
What happens in a conflict? How do you handle that?
What is a node in teradata? Explain
What is the use of stored procedures in teradata?
In Teradata, what is the significance of UPSERT command?
What are the different softwares used with their functions in teradata?
What does Amp contain and what are all the operations that it performs?
What are aggregate tables? How do you design them using teradata?
What are the functions of a Parser?
Explain Teradata performance tuning and optimization?
What is a node in teradata?
What is the difference between teradata and basic rdbms?
What is real time and near real time data warehousing?
Differentiate primary key and partition key?
How do you determine the number of sessions?
