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
Explain prerequisites and post activities of oracle database installation
Differentiate between transaction type and transaction source? : oracle accounts receivable
what are the API of GL,PO,AP
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
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
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
HOW TO SPOT AHIERARCHY?
Explain the use of table functions.
What is auto invoicing? Explain : oracle accounts receivable
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
What is autocashrule set? : oracle accounts receivable
which one is currently in used software cmpanies.