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 |
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
please explain about oracle
I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC
what is difference between inner join & nested query or subqueries
Give the stages of instance startup to a usable state where normal users may access it.
What is cardinality?
where the dff data will be stored
Explain the process of recievables in oracle financials. : oracle accounts receivable
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
Is it possible to drop a column in a table which contains only one column? How?
What is an Oracle database Full Backup?
hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.