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
Where in the Oracle directory tree structure are audit traces placed?
how to replace not in with not exist?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
what is semphore explian it?
How to clone the database using RMAN back
key flexfield structure
can we use lexical perameter in oracle plsql if yes how
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
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
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?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
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.
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
where the dff data will be stored
can u pls share responsibilities for production how to environment in odi?and how to generate report ?