Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Query Optimizer. How you optimize your qeury.
- 2 Answers
- 7270 Views
- Ericsson, I also Faced
- E-Mail Answers
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 |
What is store procedure?and how do u take the values from database and run in scripts?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
What are different types of receipt reversals ? Explain them : oracle accounts receivable
What is database schema?
What is mrc and what is its use? : oracle accounts receivable
i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value
Name two files used for network connection to a database.
Describe what redo logs are.
A scenario for amount correction & how to use amount correction functionality in AP invoices
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
what are basic modules required to implement oracle application in any oraganisation?
what is sql*loader parameters and where we will use it.
Oracle General 
