Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to tune a stored procedure?

Answer Posted / vimal

Store procedure is a pre compiled code
it is doing single task of several task
it is used to reduce the execution time
if we want to call store procedure just we call its name

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is SQL Server?

1208


What is the benefit of normalization?

1079


how you can move data or databases between servers and databases in sql server? : Sql server administration

960


Why use view instead of a table?

951


How does Report Builder support Analysis Services cubes?

153


What do mean by xml datatype?

1093


What do you mean by acid?

985


How to change the password of a login name in ms sql server?

1012


What is check constraint in sql server?

1001


What is ssrs?

129


What is the difference between Stored Procedures and triggers?

1077


What is normalization of database?

1100


What is BLOCK statements in SQL?

1261


You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1006


What is the contrast between sql and pl/sql?

1142