Interested to Buy Any Domain ? << Click Here >> for more details...
How to find No. of Records present in Each AMP or a Node
for a given Table through SQL?
- 2 Answers
- 15467 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Adding to the above,
hashrow gives the unique row hash (23 bit value) for any
value given as a parameter.
hashbucket gives the bucket value (16 bit) for any hashrow.
hashmap gives the ampno for the hashbucket.
Since, PI must be defined for any table, this hashing
function can be used to determine the ampno and the no of
rows in the amps.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain the teradata primary index mechanics in detail with a diagram.
What is the syntax for case when statement?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Give a justifiable reason why Multi-load supports NUSI instead of USI.
List the logical and conditional operators that are used with teradata along with their meanings?
Can you fastexport a field, which is primary key by putting equality on that key?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the scenarios in which full table scans occurs?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What are differences between teradata and ansi session modes in teradata?
Explain Teradata performance tuning and optimization?
How to find duplicates in a table?
What happens when a node suffers a downfall?
What is a clique?
Explain fallback in teradata?
