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
- 8790 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
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is spool space? Why do you get spool space errors?
Difference between inner join and outer join?
Define views in teradata with syntax.
What are the various indexes in teradata?
What is the opening step in basic teradata query script?
What are the steps to create a data model?
Explain how spool space is used.
Explain teradata utilities?
How to load specific no.of records using bteq, or fastload,or multiload
Discuss the advantages of using partitioned primary index in a query?
why use references rather than pointers in the public api, particularly for arguments which are modified?
During the Display time, how is the sequence generated by Teradata?
What is the maximum number of dml can be coded in a multiload script?
What is the purpose of indexes?
