What is the Query Optimizer. How you optimize your qeury.
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
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
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
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
Could you please let me know the interfaces in OM / FA??
What is auto invoicing? Explain : oracle accounts receivable
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
What are different types of receipt reversals ? Explain them : oracle accounts receivable
HOW TO SPOT AHIERARCHY?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these