What is collect State in Teradata ? what it use and how it
works??
Answer Posted / tdguy
Stores the demographic data about the columns. Very
important for better performance.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
How to eliminate product joins in a teradata sql query?
What is inner join and outer join?
What is the use of having index on table?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What are the string manipulation operators and functions associated with teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What are the functions performed by bynet?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Explain BYNET.
What are the updated features of teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
In general, how do you optimze any sql in teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.