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
- 10088 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
What is bteq utility in teradata?
What is the syntax for case when statement?
What is smp and mpp platforms?
What is meant by a Least Cost Plan?
How would you load a very large file in teradata in general?
Explain fallback in teradata?
What is difference between user and database in teradata?
What is the function of parser component in teradata?
How to eliminate product joins in a teradata sql query?
How to load specific no.of records using bteq, or fastload,or multiload
Explain and compare pros and cons of snow flake schemas?
How many tables can you join in v2r5?
Explain the types of join supports by teradata?
what are the uses of fact table and dimension table in banking project?
What is a node in teradata? Explain
