Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sat!sh
The data distribution of table among AMPs is called Skew Factor
Generally For Non-Unique PI we get duplicate values so the
more duplicate vales we get more the data have same rowhash
so all the same data will come to same amp, it makes data
distribution inequality,
One amp will store more data and other amp stores less
amount of data, when we are accessing full table, The amp
which is having more data will take longer time and makes
other amps waiting which leads processing wastage
In this situation (unequal distribution of data)we get Skew
Factor High
For this type of tables we should avoid full table scans
ex:
AMP0 AMP1
10000(10%) 9000000(90%)
in this situation skew factor is very high 90%
| Is This Answer Correct ? | 79 Yes | 3 No |
Post New Answer View All Answers
How to find duplicates in a table?
What are the string manipulation operators and functions associated with teradata?
How to view every column and the columns contained in indexes in teradata?
Describe the between keyword in teradata?
Can you fastexport a field, which is primary key by putting equality on that key?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
what are the uses of fact table and dimension table in banking project?
how can we analyze the locks ?
Explain the term 'tables' related to relational database management system?
What is upsert statement in teradata?
what are the day to day activities of teradata DBA ?
How can we check the version of Teradata that we are using currently?
What is dimensional modeling?
How do you verify a complicated sql?
What are the uses of client software involved in teradata?
