Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Query Optimizer. How you optimize your qeury.
- 2 Answers
- 7261 Views
- Ericsson, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is autocashrule set? : oracle accounts receivable
Give two methods you could use to determine what DDL changes have been made.
What is auto invoicing? Explain : oracle accounts receivable
What is auto invoicing? : oracle accounts receivable
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
What do you mean by Oracle MEDIA RECOVERY?
Explain how to close periods in ar. : oracle accounts receivable
Explain the use of table functions.
where the dff data will be stored
types of receipts and detail desription about recipts and tables effected by receipts?
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?
QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS
