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 |
How do you create a credit note against an invoice? : oracle accounts receivable
Name two files used for network connection to a database.
What is $FLEX$ and $PROFILES$?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
When creating a user, what permissions must you grant to allow them to connect to the database?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
how to replace not in with not exist?
What are the mandatory setups in setting up a PO in oracle
can u give guidance abt packages of plsql
How can you enable a trace for a session?
Give the stages of instance startup to a usable state where normal users may access it.
what is semphore explian it?