What is the Query Optimizer. How you optimize your qeury.
Answer Posted / 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 |
Post New Answer View All Answers
what are basic modules required to implement oracle application in any oraganisation?
Is there any link between pr form(purchse requisition)and po form(purchase order)
What are different types of receipt reversals ? Explain them : oracle accounts receivable
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
What is autocashrule set? : oracle accounts receivable
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
What is auto invoicing? Explain : oracle accounts receivable
Give two methods you could use to determine what DDL changes have been made.
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
Explain the payment term in ar. : oracle accounts receivable
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
Where in the Oracle directory tree structure are audit traces placed?
1. What is PO rate variance gain and loss?
default triggers available for reports
What is supporting issues GL AP and AR?