Archives of the TeradataForum

Message Posted: Mon, 02 Sep 2002 @ 18:36:17 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>