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

Is sql dba a good career? : SQL DBA

0 Answers  

What is the use of procedures?

0 Answers  

What is a trigger in pl/sql?

1 Answers  

how to use myisamchk to check or repair myisam tables? : Sql dba

0 Answers  

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

0 Answers  

How do you break a loop in pl sql?

0 Answers  

what is d diff between grant,commit,rollback n savepoint

1 Answers  

Why do we use triggers?

0 Answers  

List and explain the different types of join clauses supported in ansi-standard sql?

0 Answers  

How can you tell the difference between an index and a view?

0 Answers  

What does fetching a cursor do?

0 Answers  

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories