can you explain performance tunning in oracle(sql,PL/SQL)
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
How to write numeric literals in oracle?
How does the on-delete-cascade statement work?
When do you get a .pll extension in oracle?
How many data types are supported?
How to convert numbers to characters in oracle?
What is open database communication (odbc) in oracle?
What are the differences between lov and list item?
Why do we use coalesce function in oracle?
What are the different types of database objects?
How can I create database in oracle?
What is the maximum number of triggers that can be applied to a single table?
How to drop a stored function?
How do I escape a reserved word in oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Can a formula column be obtained through a select statement ?