What is the Query Optimizer. How you optimize your qeury.
Answers were Sorted based on User's Feedback
Answer / bipin yadav
Query Optimizer is means how to imrprove the perfomance of
the query,to this we have to extract the explain plan of
that quey usin the set option on the SQL PLUS,using the
commond "SET AUTOTRACE TRACE EXP" we can see the query
cost....:-)
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / madhu sekhar
This answer i told. I am using PL/SQL DEVELOPER tool. In
that i go for Explain plan method based on cost of the
query i optimize my Query.
If some others answers is the pls share with me
| Is This Answer Correct ? | 1 Yes | 2 No |
A scenario for amount correction & how to use amount correction functionality in AP invoices
What is store procedure?and how do u take the values from database and run in scripts?
Can We Restore a Table that accidantly dropped.
How would you determine what sessions are connected and what resources they are waiting for?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
Explain the process of recievables in oracle financials. : oracle accounts receivable
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
What type of index should you use on a fact table?
What is the difference between recovery and restoring of the oracle database?
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me