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
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.
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
how to write customizations in po
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Explain the payment term in ar. : 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?
How many segment are present in Oracle Manufacturing
How would you determine what sessions are connected and what resources they are waiting for?
Explain about party and customer in ar : oracle accounts receivable
What do you mean by hz_ in customer tables? : oracle accounts receivable
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5