How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?
- 12 Answers
- 26983 Views
- IBM, TCS, UHD, I also Faced
- E-Mail Answers
Answer Posted / kapil
By using index (not always)
by using bulk fetch
by using exists and not exists in place of in and not in
clause.
by avoiding implicit conversion by oracle
ex: if in employee table emp_no is varchar then
if we query the data from employee table by
where cluase like employee_number = 123 then oracle will
have to implictly convert the number 123 to
varhcar '123'and will require time
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How many postgresql users are there, worldwide?
How do you rank data in sql?
How to handle bulk data?
What are the types of variable use in pl sql?
What is crud sql?
What is sql server and ase?
Is oracle sql free?
what is primary key? : Sql dba
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What are the different types of database management systems?
How do you rename a table in sql?
How is use pl and sql?
How do I count duplicates in sql?
Which function is used to return remainder in a division operator in sql?
How can triggers be used for the table auditing?
