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 primary characteristics of the Teradata.
what is sysdba and sysdbc ? which has high priority ?
What are the different functions included in the server software?
Differentiate database data and data warehouse data?
What is the purpose of indexes?
Explain parsing engine in teradata?
What are types of partition primary index (ppi) in teradata?
What is stored procedure in teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
if collect stats but it show low confidence why?
What is meant by a Highest Cost Plan?
What is a three-tier data warehouse?
Explain the most common data types used in teradata?
What do you mean by ttu in teradata?
What is meant by a Channel Driver?