Finding Skewed Tables in Teradata
Skewed Tables in Teradata Teradata distributes its data for a given table based on its Primary Index and Primary Index alone .If this Primary Index is not selected appropriately it can cause performance bottle necks. Following are general parameters we should consider while creating Primary Indexes 1:Access Path 2:Volatility 3: Data Distribution Volatility is usually not an issue in a well designed database .That is to say we do not expect...