Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 14 Apr 2005 @ 13:03:05 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: How are stored procedures stored on AMPs.
From:   Dennis Calkins

  I have a database with 10MB. There 10 apms assigned to this database. (1 MB per amp)  

  I create a Stored procedure which uses 1MB.  

  Then I try to create another stored procedure it fails due to space issue, even thought there is 9 MB left.  

what are the names of your 2 stored procedures?

Stored procedures are HASH by the name of the stored procedure ( or is the name of the database I forget ) and then stored entirely on that one amp.

Therefore when the parser needs to start a stored procedure in response to a SQL call it is a single amp request to retrieve the Binary code of the stored procedure.

I agree, The space required for stored procedures can be very skewed....

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