 |
 |
Archives of the TeradataForum
Message Posted: Mon, 01 Oct 2001 @ 14:58:11 GMT
| Subj: | | Re: Multiload status |
| |
| From: | | Ruth Fenwick |
Thomas,
Table has a UPI. Multiload was run before I reviewed application team's script. Table had 3 NUSI's on it, one very non-unique. It was
already into the application phase when it was cancelled. Since we couldn't go back, we went forward with the load, with the 3 NUSI's on
it. (NUSI's have since been dropped for on-going loads). BTW, job ran for 11 hours after restart, I was looking for some way to correlate
the CPU usage and accesses with the number of secondary indexes to be built
Ruth Fenwick
IA&DSS Team Leader
Information Resource Management
Hudson's Bay Company
| |
