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

Why do we need view in sql?

730


If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3698


Are there any features that are decommissioned in 11g that are not present in 11g?

1819


How many rows can sqlite handle?

780


what are all types of user defined functions? : Sql dba

755






How many sql databases can you have on one server?

757


Can you join views in sql?

718


Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

760


What is the use of %rowtype?

747


how to select unique records from a table? : Sql dba

825


What is trigger in flip flop?

729


Explain table and field in sql?

780


How do I count rows in sql?

739


How do you clear the screen in sql?

781


When is the explicit cursor used ?

764