How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?
Answer Posted / shailesh
We can improve the performance by create indexes on the use
tables which is used in the procedure,function and packages
And with the help of these indexes we can improve the
performance.
Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
what is the command used to fetch first 5 characters of the string? : Sql dba
Is join same as left join?
What is varchar used for?
what is a table in a database ? : Sql dba
What is a native sql query?
How to look at the current sql*plus system settings?
What is the difference between local and global temporary table?
what is query cache in mysql? : Sql dba
What is the difference between nested table and varray?
Differentiate pl/sql and sql?
How to display the current date in sql?
Show code of a cursor for loop.
Can a primary key be a foreign key?
What is the difference between numeric and autonumber?
What is varchar sql?