Interested to Buy Any Domain ? << Click Here >> for more details...
What are the steps you take to tune(performance tuning) the code in plsql?
- 4 Answers
- 18092 Views
- Cap Gemini, Infosys, TCS, I also Faced
- E-Mail Answers
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
Can delete statement be rollbacked?
What is pl/sql table? Why is it used?
What is cte?
How can we avoid duplicating records in a query?
What is dba in sql? : SQL DBA
Does truncate free space?
explain normalization concept? : Sql dba
How do you pronounce sql?
how to fetch common records from two tables? : Sql dba
What are operators available in sql?
How to look at the current sql*plus system settings?
What are character functions in sql?
What are analytic functions in sql?
What is the use of double ampersand (&&) in sql queries? Give an example
What are different clauses used in sql?
