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 improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?

Answer Posted / shailesh

We can improve the performance by create indexes on the use
tables which is used in the procedure,function and packages
And with the help of these indexes we can improve the
performance.

Is This Answer Correct ?    14 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

where are cookies actually stored on the hard disk? : Sql dba

975


what is bdb (berkeleydb)? : Sql dba

974


What is the command used to fetch first 5 characters of the string?

1334


What are different categories of sql commands?

1068


Cite the differences between execution of triggers and stored procedures?

1028


How does cross join work?

875


What do you understand by case manipulation functions?

952


What sql database should I use?

1072


Does google use sql?

912


How to prepare for oracle pl sql certification?

1010


What is procedure explain with program?

950


What is trigger and stored procedure in sql?

976


How can we find duplicate records in a table?

891


how many columns can be used for creating index? : Sql dba

897


Which kind of parameters cannot have a default value in pl sql?

1071