Interested to Buy Any Domain ? << Click Here >> for more details...
can you explain performance tunning in oracle(sql,PL/SQL)
- 2 Answers
- 4786 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 oracle instant client?
Differentiate between translate and replace?
How to add a new column to an existing table in oracle?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
How do I use unicode codesets with the weblogic jdriver for oracle driver?
26. Display the earliest shipping date in the format: DD/MON/YYYY
find out first highest salary?
10 Answers Verinon Technology Solutions,
how to get the index id?
find the second highest salary of the emp table
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
Explain self joins in oracle?
How to generate query output in html format?
Oracle General 
