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
- 10216 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
List out all forms of LOCKS that are available in Teradata.
What is a sparse index?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is the basic syntax for teradata select statement?
Why does varchar occupy 2 extra bytes?
What is the multi-insert?
What are the steps to create a data model?
What are the scenarios in which full table scans occurs?
How do you see a ddl for an existing table?
How to Extract data from multiple legacy systems?
Highlight the need for Performance Tuning.
How many types of joins are there in teradata?
What are the design features involved in teradata?
What are differences between teradata and ansi session modes in teradata?
List out some of the primary characteristics of teradata.
