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
- 8754 Views
- I also Faced
- E-Mail Answers
Answer Posted / siva reddy
in case we are using nusi in this swicthvation subtable is created same amps.it is one of the full table scan but not full table scan.it's scan only all amps sub table.if any one of the match it will disply.here no allgorithem can be performed.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What exactly do you know about catching in teradata?
Why do you get spool space errors? How do trouble-shoot them?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What are the joins in teradata and how many types of joins are there in teradata?
Define views in teradata with syntax.
Why teradata is used?
What is called partitioned primary index (ppi)?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What is multi insert?
how many modules are there in telecome domain?how to explain the architecture?
Explain vproc in teradata?
What is the difference between teradata and basic rdbms?
What interface is used to connect to windows based applications?
Explain the new features of teradata?
What is basic teradata query language?
