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
- 10091 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
Highlight the differences between Primary Key and Primary Index.
Why is the case expression used in teradata?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What are the multiload utility limitations?
What are the components provided on node?
What are the updated features of teradata?
What is the primary index in teradata?
What is the difference between teradata and basic rdbms?
What can be achieved by using the teradata rdbms?
Highlight a few of the important components of Teradata?
In general, how do you optimze any sql in teradata?
how can we analyze the locks ?
How is MLOAD Teradata Server restarted after execution?
Highlight all the modes that are present under Confidence Level.
In BTEQ, how are the session-mode parameters being set?
