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

Answer Posted / syam

Hi Shailesh,


let me know that how can i improve performence of
procedures by useing indexes

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I clear the screen in sql plus?

553


What are database links used for?

595


What are the steps for performance tuning.

847


What are the different types of constraints?

566


In what condition is it good to disable a trigger?

558






What is the difference between inner join and natural join?

513


What are predefined functions in sql?

535


What is the maximum number of rows in sql table?

551


Show how functions and procedures are called in a pl/sql block.

588


what is table? : Sql dba

574


Can we use insert statement in function?

516


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

595


How to start oracle sql developer?

560


What are sql functions? Describe in brief different types of sql functions?

492


What is difference between nchar and nvarchar?

548