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

Answer Posted / debasis bose

Using Views, instate of multiple tables.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

760


Is big data nosql?

692


how to convert character strings to numeric values? : Sql dba

771


Explian rowid, rownum?

751


Can we rollback after truncate?

752






What is auto increment feature in sql?

819


what are the 'mysql' command line arguments? : Sql dba

839


What are packages in pl sql and also explain its advantages?

708


What are instead of triggers?

790


write an sql query to find names of employee start with 'a'? : Sql dba

775


Are pl sql variables case sensitive?

769


Can we join more than 2 tables in sql?

678


Can 2 queries be executed simultaneously in a distributed database system?

859


What does fetching a cursor do?

801


What is a .db file?

724