 |
 |
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.
| |
