Interested to Buy Any Domain ? << Click Here >> for more details...
can you explain performance tunning in oracle(sql,PL/SQL)
- 2 Answers
- 4781 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 will I find the first 5 highest salaried employees in each dept in oracle.
Explain what are clusters?
 How to use an oracle sequence generator in a mapping?
Describe an oracle table?
Explain the use of full option in exp command.
What is a sub query? What are its various types?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
What is a directory object?
What does COMMIT do ?
How to load data through external tables?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
Explain the characteristics of oracle dba?
Oracle General 
