Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Query Optimizer. How you optimize your qeury.
- 2 Answers
- 7141 Views
- Ericsson, I also Faced
- E-Mail Answers
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
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
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
default triggers available for reports
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
What is the difference between conversions and interfaces? : oracle accounts receivable
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
how to replace not in with not exist?
What view would you use to determine free space in a tablespace?
what are the tools used for oracle 10g in real time.
Where in the Oracle directory tree structure are audit traces placed?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
What is the importance of batch source set up in ar? : oracle accounts receivable
