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
- 10421 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
Define views in teradata with general syntax.
What are default access rights in teradata? What explicit right can be given to a user?
Explain and compare pros and cons of snow flake schemas?
How many sessions of MAX is PE capable of handling at a particular time?
Comment whether bottleneck is an error or not.
Explain the term 'database' related to relational database management system?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
When tpump is used instead of multiload?
How do you see a ddl for an existing table?
Explain teradata architecture in detail with a diagram.
What is meant by a Virtual Disk?
What is meant by a Clique?
What are the available primary index types?
What is meant by a Highest Cost Plan?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
