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 |
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
what is different between inline query,subquery& corelated query?
write a query to find the third maximum salary of a employee.(table:employ col name:salary)
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
What is $FLEX$ and $PROFILES$?
Give the reasoning behind using an index.
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
statement string in open is null or 0 length ORA-40735
8. Supporting AP, AR and GL?
What type of index should you use on a fact table?
What is autocashrule set? : oracle accounts receivable
What is the sql query to find the employee who has Nth maximum salary?