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 switch column,colums cost in oracle?

0 Answers   Metric Stream,

what is the difference between trigger and constraint?

3 Answers   HSBC,

when normalization is required

3 Answers   HCL,

What is rename in sql?

0 Answers  

How to create a menu in sqlplus or pl/sql?

0 Answers  




What is loop in pl sql?

0 Answers  

What is cursor in pl sql?

0 Answers  

How to run pl/sql statements in sql*plus?

0 Answers  

Why cross join is used?

0 Answers  

How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

10 Answers   Mind Tree, Polaris, Sonata,

What is the difference between union and union all command?

0 Answers  

What are the advantages of pl sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories