Archives of the TeradataForum
Message Posted: Mon, 02 Sep 2002 @ 18:36:17 GMT
| Subj: || || Re: Spool space for Teradata users |
| From: || || John Hall |
Just a note on your UPDATE: Table DBC.DATABASESPACE is a non-hashed table. A non-hashed system table appears to behave the same as a
hashed table, but the data is actually local to the AMP - no matter the definition of the primary index. This means that you can't use the
PI to access a non-hashed table. Instead, a full-table (or all rows) scan must be performed.
So while your routine will execute correctly, I'm sure that it's not doing a PI update. I think that you'll find that the query is
actually doing an all-rows scan on DBC.DATABASESPACE.