can you explain performance tunning in oracle(sql,PL/SQL)
- 2 Answers
- 3909 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What do you understand by a database object? Can you list a few of them?
Explain the use of record option in exp command.
How to connect asp pages to oracle servers?
Explain the use of tables option in exp command.
List the parts of a database trigger.
How do I start tns listener?
What is an oracle cursor variable?
what are the default admin accounts in Oracle 10g ?
Why do you create or replace procedures rather that drop and recreate.
What is an oracle wallet?
What is a sub query and what are the different types of subqueries?
What is bind variable in oracle 11g?
How to set up autotrace for a user account?
How to pass parameters to procedures?
How to drop a tablespace?
