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
- 10215 Views
- I also Faced
- E-Mail Answers
Answer Posted / saravanan
If your question is about how Parsing engine would fetch
DEPTID=10, it will undergo a FULL TABLE scan since Dept_Id
is a Non unique secondary index.
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Differentiate database data and data warehouse data?
Why does varchar occupy 2 extra bytes?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Write a program to show the parser component used in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
List the logical and conditional operators that are used with teradata along with their meanings?
How is MLOAD Client System restarted after execution?
In Teradata, what is the significance of UPSERT command?
what is object level locking ? where do appear this type of locking ?
How do you see a ddl for an existing table?
Explain teradata utilities. What is multiload, fast load, tpump?
What type of indexing mechanism do we need to use for a typical data warehouse?
how do you manage the production space. what are the proactive methods you can take ?
Name the five phases that come under MultiLoad Utility.
Explain and compare pros and cons of start schemas?
