Sign Up Login


  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 a trigger ?

11 Answers   Accenture, BirlaSoft,

What is db journal file?

0 Answers  

what is column? : Sql dba

0 Answers  

How do I view a view in sql?

0 Answers  

what are the different type of sql's statements ? : Sql dba

0 Answers  




Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,

What is ttitle and btitle?

0 Answers  

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

Can you have multiple SPs with the same name on a database?

6 Answers   CGI,

What are the differences between implicit and explicit cursors?

0 Answers  

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

How many commands are there in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories