Answer Posted / tdguy
highly non unique PI values, more number of null values can
create a hot amp condition., which means one or more amps
will be holding more rows than other amps. Distribution
occurs unevenly. This can cause out of spool space error.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are the scenarios in which full table scans occurs?
Can you fastexport a field, which is primary key by putting equality on that key?
List out some of the primary characteristics of teradata.
What do high confidence, low confidence and no confidence mean in explain plan?
What is bteq script in teradata?
When tpump is used instead of multiload?
Explain the types of join supports by teradata?
Explain the term 'row' related to relational database management system?
During the Display time, how is the sequence generated by Teradata?
What are types of partition primary index (ppi) in teradata?
Why are oltp database designs not generally a good idea for a data warehouse?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What are the different functions included in the server software?
What exactly do you know about catching in teradata?
What is difference between user and database in teradata?