can you explain performance tunning in oracle(sql,PL/SQL)
- 2 Answers
- 3721 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 |
Can we create index on views?
19 Answers CTS, Syntel, TCS,
How view is different from a table?
What is a Sequence ?
What are the different types of database objects?
What is the data pump import utility?
How to display employee records who gets more salary than the average salary in the department?
How to create a new view in oracle?
Explain joins in oracle?
What is the difference between column level constraints and table level constraints?
14 Answers IBM, TCS,
difference between oracle8i and oracle9i
what are the things that you consider while creating indexes on partitioning tables?
What is use of oracle?
Oracle General 
