How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?
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
What is a temporal data type?
What is the difference between delete and truncate commands?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
How do you update f as m and m as f from the below table testtable?
How to write html code in pl sql?
What is relationship? How many types of relationship are there?
Why is the cursor important?
What is the maximum number of rows in sql table?
What is an example of translating a date into julian format?
Is sql a dbms?
What is a left join?
Can we use loop in sql?
how can we know the number of days between two given dates using mysql? : Sql dba
what is the difference between rownum pseudo column and row_number() function? : Sql dba
Can we insert in sql function?