Is the Stored Procedure effects the size of the database

prashu · New User Joined: 12 Jun 2005 Posts: 7 Location: hyderabad

1. hi can any one tell me
is the stored procedure effects the size of the database.

priyesh.agrawal · Posted: Thu Jun 23, 2005 7:34 pm

I think Yes.

Regards,

Priyesh.

brganeshbabu · New User Joined: 23 Jun 2005 Posts: 34 Location: Chennai

Certainly a stored procedure affects the size of the database

paru · New User Joined: 24 Jun 2005 Posts: 9 Location: INDIA

Using Stored Procedure will reduce the size of the database.

Regards,

Paru

Karthikt · New User Joined: 15 Aug 2005 Posts: 51

To my knowledge, I feel that stored procedures simplifies the SQL queries and maintains integrity and security. Can you explain me more, how it has impact on the size of the database?

If several programs want to execute a set of SQL queries, then they will call a stored procedure which has functionalites of such SQL queries by approriate CALL statement. This prevents the one from knowing DB2 relaed information and adds security to the system.