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.
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 spool space?
What are the things to be considered while creating secondary index?
What is the maximum number of dml can be coded in a multiload script?
What is primary index and secondary index?
Difference between stored procedure and macro?
How to find duplicates in a table?
What is partitioned primary index (ppi)?
What is the use of fallback?
what is sysdba and sysdbc ? which has high priority ?
Describe the set operators in teradata.
What is TPD?
Differentiate database data and data warehouse data?
Define views in teradata with syntax.
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is the basic syntax for teradata select statement?