What is the Query Optimizer. How you optimize your qeury.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where in the Oracle directory tree structure are audit traces placed?

2133


how to replace not in with not exist?

3199


HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

1595


what is semphore explian it?

2249


How to clone the database using RMAN back

1621






key flexfield structure

1609


can we use lexical perameter in oracle plsql if yes how

1830


TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

2843


I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

1830


Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2366


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1640


What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3352


IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

1630


where the dff data will be stored

1810


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

1915