What is the Query Optimizer. How you optimize your qeury.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Explain how to close periods in ar. : oracle accounts receivable
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?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What is auto invoicing? : oracle accounts receivable
How do you switch from an init.ora file to a spfile?
What is store procedure?and how do u take the values from database and run in scripts?
what is the querry to get first 10 records from the emp table?(emp no is the primary key)
Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC
When creating a user, what permissions must you grant to allow them to connect to the database?
what is the difference b/w oracle8i and oracle9i