Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
- 2 Answers
- 4717 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
The OPTIMIZER_MODE initialization parameter Statistics in the
Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER
SESSION command hints in the statement.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nishi
This value causes the optimizer to the cost-based approach for all SQL statements in the session regardless of the presence of statistics and to optimize with a goal of best throughput.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can the query output be sorted by multiple columns in oracle?
How to drop an existing table in oracle?
Query to retrieve record for a many to many relationship ?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is a View ?
What is mean by Program Global Area (PGA) ?
Is there an oracle sql query that aggregates multiple rows into one row?
How to get a list of all tables in the database?
How many file formats are supported to export data?
Can I create users through internet explorer in oracle 10g?
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
How to upsert (update or insert into a table)?
Oracle General 
