Interested to Buy Any Domain ? << Click Here >> for more details...
can you explain performance tunning in oracle(sql,PL/SQL)
- 2 Answers
- 4635 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 |
How to connect to a local oracle 10g xe server?
Please explain drop constraint oracle?
How to use like conditions in oracle?
Name the three major set of files on disk that compose a database in Oracle?
12 RULES OF RDBMS
How to update values on multiple rows in oracle?
How to handle a single quote in oracle sql?
what are the diffeenes between oracle 9i,oracle 10g
What is Read-Only Transaction ?
What are various joins used while writing SUBQUERIES?
How do I uninstall oracle 11g?
when loggined as SYSTEM,how to display all the users of database using sql query?
Oracle General 
