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 the dff data will be stored

1801


How would you determine who has added a row to a table?

1792


What is mrc and what is its use? : oracle accounts receivable

629


What are different types of transactions in ar? : oracle accounts receivable

741


Difference between transaction type and transaction sources. : oracle accounts receivable

575






What is auto invoicing? Explain : oracle accounts receivable

612


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

1831


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

1646


i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

1851


i want to know about the javaBean.what is its purpose and how it can use in Forms.

1833


Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

732


What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

685


What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

3985


8. Supporting AP, AR and GL?

1811


Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

735