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

What is record in pl sql?

596


What is the purpose of primary key?

535


What is clustered index in sql?

592


What is pl sql record in oracle?

567


What is spool?

595






What is dbo in sql?

536


What is trigger and stored procedure in sql?

558


Is sql a dbms?

536


What is view explain with example?

521


What is the left table in sql?

519


Why function is used in sql?

524


i have some prob lem to tell me about my self in interview first round ...

1706


How do I view tables in sql developer?

518


Is delete faster than truncate?

552


Explain the purpose of %type and %rowtype data types?

506