Archives of the TeradataForum
Message Posted: Tue, 28 Dec 1999 @ 15:21:25 GMT
| Subj: | | Re: Vproc Usage |
| |
| From: | | Sam Sterling |
You might also check on NUSI's for skewing. A very Non-Unique Secondary Index can slow down a lot. If you have a secondary index
on something that has only a few values, like "Y" or "N" or a business unit or day of the month or something, you have a few rows (on
a few VPROCs) with a LOT of data.
Sam Sterling
Sr. Consultant
www.SSterling.com
Admin Comment: When last tried, the URL in this Post no longer functioned.
|