Interested to Buy Any Domain ? << Click Here >> for more details...
How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?
- 12 Answers
- 28783 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
difference between anonymous blocks and sub-programs.
how can we submit a form without a submit button? : Sql dba
which types of join is used in sql widely? : Sql dba
what are date and time data types in mysql? : Sql dba
What is a loop in sql?
Is pl sql a scripting language?
Explain the rollback statement?
what are the types of join and explain each? : Sql dba
How many parts of a pl sql block are optional?
Why do we use subquery?
How do you declare a constant?
What is before trigger?
What are the two types of periodical indexes?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
what is the difference between sql and t-sql? : Transact sql
