Interested to Buy Any Domain ? << Click Here >> for more details...
can you explain performance tunning in oracle(sql,PL/SQL)
- 2 Answers
- 4676 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 |
Explain the difference between replace() and translate() functions in oracle?
what is difference between where clause and having clause?
Which of the following is not a database object TABLESPACE TABLE INDEX NONE
what is the syntax of INSERT command?
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
Give the advantages and disadvantages of clusters.
What is a cursor and what are the steps need to be taken?
What are the differences between primary key and unique key?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
How to list all user accounts in oracle?
What is a Synonym ?
Is it possible to split the print reviewer into more than one region ?
Oracle General 
