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
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....
| 
