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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?

Question Posted / lalamaheshkumar

Answers were Sorted based on User's Feedback



How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ..

Answer / bala

By avoiding sql statements & select INTO kind of statements.
To improve better creating cursors to hold data.
Indexing is the way to tune the database tables.
so, mostly try to avoid Hard Coding in the select
statements..

Is This Answer Correct ?    2 Yes 4 No

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ..

Answer / ramprasad.s

hi



using oracle-Tuning




sun_ramprasad@yahoo.com

Is This Answer Correct ?    1 Yes 7 No

Post New Answer

More SQL PLSQL Interview Questions

What is ttitle and btitle?

0 Answers  

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,

What is clause in sql?

0 Answers  

What is sql and explain its components?

0 Answers  

Do you understand the meaning of exception handling?

3 Answers  

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

0 Answers  

What is the purpose of cursors in pl/sql?

0 Answers  

How to fetch alternate records from a table?

0 Answers  

What is embedded sql what are its advantages?

0 Answers  

What is a join?Explain the different types of joins?

6 Answers   Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,

What is the size of partition table?

0 Answers  

in table there r so many rows write a query which two rows r updated last two day befor?

3 Answers   Exilant,

For more SQL PLSQL Interview Questions Click Here
Categories