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
- 17892 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
What is a null value?
Can you have a foreign key without a primary key?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What is sql used for?
Are stored procedures faster than queries?
What is trigger price?
What is your daily office routine?
Can we join tables without foreign key?
How do I find sql profiler?
how to calculate expressions with sql statements? : Sql dba
How can you view the errors encountered in a trigger?
what is bcp? When is it used?
How to convert comma separated string to array in pl/sql?
What are schema-level triggers?
Can a table have no primary key?
