Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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