Home Page for the TeradataForum

Archives of the TeradataForum

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

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

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016