How would you go about generating an EXPLAIN plan?

Answer Posted / gogune

Thr'u command

explain plan for <select statement>

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are basic modules required to implement oracle application in any oraganisation?

1700


What is autocashrule set? : oracle accounts receivable

734


Explain the process of recievables in oracle financials. : oracle accounts receivable

656


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

1822


1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

16358






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

1768


key flexfield structure

1601


What is chargeback invoice? How do we create it? : oracle accounts receivable

725


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


HOW TO SPOT AHIERARCHY?

1848


what is the link between suppliers and banks in ap module in oracle apps? And also query?

2014


what are the API of GL,PO,AP

1773


Why more redos are generated when the oracle database is in begin backup mode?

662


What is db_recovery_file_dest in oracle? When do you need to set this value?

648


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?

2359