can you explain performance tunning in oracle(sql,PL/SQL)
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 |
What is backup in Oracle?
Is insert autocommit in oracle?
How to build data dictionary view an new database?
What is oracle rowcount?
Can you create a synonym without having a table?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What is raw datatype in oracle?
How to export data to a csv file?
Explain the use of record option in exp command.
How to bring a tablespace online?
What is a Redo Log ?
which clause we are not used in where clause?