What are the steps you take to tune(performance tuning) the code in plsql?
Answer Posted / mathivanan
1.Create indexes
2.keep up to date statistics on tablese
3.Analyse execution plans using trace utilities
4.Make use of Bulk collect,For all,returning bulk collect into.
5.Use hints when necessary
6.Minimize datatype conversions
7.use PLS_INTEGER or BINARY_INTEGER for integer Arithmetic,use BINARY_FLOAT and BINARY_DOUBLE for floating-point arithmetic
8.pin frequently used packages in shared pool memory
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are inbuilt functions in sql?
What is union and union all keyword in sql?
What is sql profiler in oracle?
What is type and rowtype in pl sql?
What is input buffer in sql*plus?
Is sql open source?
What is the use of count (*) in sql?
State few characteristics of pl/sql?
explain access control lists. : Sql dba
How to run pl sql program in mysql?
What is cold data?
How to select all records from the table?
Does mysql support pl sql?
What is basic structure of pl sql?
How do I run a sql query in pgadmin 4?