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
- 10223 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 is spool space? Why do you get spool space errors? How do trouble-shoot them?
Explain parsing engine in teradata?
Why managing the data is important?
How is MLOAD Teradata Server restarted after execution?
How is MLOAD Client System restarted after execution?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
if collect stats but it show low confidence why?
What is multi insert?
What is the difference between fastload and multiload? Which one is faster?
What are the various reporting tools in the market?
What do you mean by tpt in teradata?
Why are oltp database designs not generally a good idea for a data warehouse?
What are the things to be considered while creating secondary index?
What is the use of stored procedures in teradata?
Highlight a few of the important components of Teradata?
