Archives of the TeradataForum
Message Posted: Wed, 29 Dec 1999 @ 12:56:17 GMT
| Subj: || || Re: Vproc Usage |
| From: || || Andy Blevins |
You need to look at the query or queries that are running and see what type of access they are using. It is possible for example to have
a large table using a NUPI that has very even distribution on the system. The NUPI could be on customer ID which would mean all customer
numbers that were the same would be on the same AMP. Someone could then try and access all customer numbers that start with 99 or access the
data by not using the index which could cause the query to appear to be running against skewed data.