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
- 18261 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
Are stored procedures faster than queries?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
what is a view? : Sql dba
Explain alias in sql?
Is pl sql still used?
How to pipe multiline string to isql?
What does := mean in pl sql?
explain advantages of myisam over innodb? : Sql dba
What are the key differences between SQL and PL SQL?
Can you selectively load only those records that you need? : aql loader
In a distributed database system, can we execute two queries simultaneously?
How to execute a stored procedure?
What are the ddl commands?
Can we write dml inside a function in sql server?
What are all types of user defined functions?
