Archives of the TeradataForum
Message Posted: Thu, 14 Apr 2005 @ 13:03:05 GMT
| 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
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....