Interested to Buy Any Domain ? << Click Here >> for more details...
can you explain performance tunning in oracle(sql,PL/SQL)
- 2 Answers
- 4684 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sushant
It is just to check whether the query which we provide is
quiet simple n takes less time to compile as compared to
other querys !!!
Mostly its a DBA part !!
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sudipta santra
First u need to take explain plan of the proposed query then
you can identify for which join condition is costlier. By
watching this then you can modify the condition logic of the
query.
There are so many logic for make a query tune.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the difference between substr & instr functions?
What is difference between a formal and an actual parameter?
What is a package ? What are the advantages of package ?
Whats the benefit of dbms_stats over analyze?
How to get a list of all tables in the database?
When does a Transaction end ?
What is a nested table and how is it different from a normal table?
What are the composite date types in oracle?
Is there any function in oracle similar like group_concat of mysql?
How to define an explicit cursor in oracle?
what is the difference between authorization and authentication?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
Oracle General 
