Abinitio - What is the purpose of having stored procedures in a database?

GeekInterview.com > Interview Questions > Data Warehousing > Abinitio

Go To First | Previous Question | Next Question

Abinitio | Question 21 of 193

What is the purpose of having stored procedures in a database?

Total Answers and Comments: 3

Last Update: February 09, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: Sunil

Main Purpose of Stored Procedure for reduse the network trafic and all sql statement executing in cursor so speed too high.

Above answer was rated as good by the following members:
manmeet_uk

December 09, 2005 03:59:59

Sunil

RE: What is the purpose of having stored procedures in...

Main Purpose of Stored Procedure for reduse the network trafic and all sql statement executing in cursor so speed too high.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

October 05, 2007 05:49:23

Chandra

RE: What is the purpose of having stored procedures in...

Stored procedure is precompiled SQL block. So it reduces the execution time.

Is this answer useful? Yes | No

0 1

Overall Rating: -1

February 09, 2008 05:46:28

sreyas kvm

Member Since: February 2008 Contribution: 10

RE: What is the purpose of having stored procedures in a database?

Stored procedure is a pre-compiled execution block,so they do not want to wait as the time for compilation.It is call from the server.It reduce the execution time

Is this answer useful? Yes | No

0 1

Overall Rating: -1

Go To Top