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
- 10422 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 do you mean by teradata sql assistant?
Define views in teradata with general syntax.
how do you manage the production space. what are the proactive methods you can take ?
How to eliminate product joins in a teradata sql query?
What is a dimension table?
Explain the term 'columns' related to relational database management system?
What are the design features involved in teradata?
What are the advantages of teradata?
What is dimensional modeling?
What are the steps involved after the disk manager passes the request?
What is meant by Teradata Gateway?
Discuss the advantages of using partitioned primary index in a query?
What are the various indexes in teradata?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Name the five phases that come under MultiLoad Utility.
