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 |
I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
Could you please let me know the interfaces in OM / FA??
i have marks in table,how to find total?
can we use lexical perameter in oracle plsql if yes how
hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent
please explain about oracle
What is the Symbol use for Inner Join
Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
What view would you use to look at the size of a data file?
How many segment are present in Oracle Manufacturing