Interested to Buy Any Domain ? << Click Here >> for more details...
can you explain performance tunning in oracle(sql,PL/SQL)
- 2 Answers
- 4787 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
When do we use group by clause in a sql query?
What is oracle datasource?
What do you know about normalization? Explain in detail?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is the exact use of Collections?
How to create an oracle database manually?
State all possible different index configurations a table can possibly have?
how the indexes are stored in the Oracle Database?
What are the types of trigger in oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
How to commit the current transaction in oracle?
Explain about the analyze command in oracle?
How to write date and time literals in oracle?
What are data pump export and import modes?
When system tablespace is created?
