Interested to Buy Any Domain ? << Click Here >> for more details...
can you explain performance tunning in oracle(sql,PL/SQL)
- 2 Answers
- 4673 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 |
What is a package in oracle?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How to assign a table row to a record variable?
What is the max number of columns in an oracle table?
How to select the name of employee who is getting maximum sal with out using subquery
State and explain the different types of data models?
What is the meaning of recursive hints in oracle?
What is difference between sid and service name in oracle?
Who i will insert 1 lacks record in a Database table
What is the relationship among database, tablespace and data file?
Can a property clause itself be based on a property clause ?
What is a cursor variable?
Oracle General 
