Interested to Buy Any Domain ? << Click Here >> for more details...
In the Primary Index, what is the score of AMPs that are actively involved?
- 1 Answers
- 1154 Views
- I also Faced
- E-Mail Answers
Answer / Sankatesh Raman
In a Primary Index in Teradata, each Active Memory Partition (AMP) that is actively involved in processing queries associated with the index receives a score. The higher the score, the more work the AMP is doing for the index.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the available primary index types?
What is teradata? Also, list out some of the primary characteristics of teradata.
How to view every column and the columns contained in indexes in teradata?
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What happens in a conflict? How do you handle that?
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
Why do Hash joins usually perform better than Merge Joins?
what is DYNAMIC SQL in TD?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
List the logical and conditional operators that are used with teradata along with their meanings?
What are default access rights in teradata? What explicit right can be given to a user?
Teradata 
