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 indexes?

0 Answers  

How to copy a table in another table with datas?

9 Answers  

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

How many clustered indexes can be created on a table?

0 Answers  

what is clause? : Sql dba

0 Answers  




How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

what is explain plan?, given an example...

3 Answers   Polaris,

Enlist the characteristics of pl/sql?

0 Answers  

What does inner join mean?

0 Answers  

Explain what is a view?

0 Answers  

What does where 1/2 mean in sql?

0 Answers  

What is difference between sql and mysql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories