Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
- 2 Answers
- 4611 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 |
how to handle exceptions in post production
How to delete multiple rows from a table in oracle?
How to check the oracle tns settings?
Give the various rollback segment states.
12. Display the client name in upper case only and in lower case only.
What are the advantages of oracle?
After using set unused can we enable the column again to use? Please give me some answers....
how to do daily transactions with out sql* loader control file regesterd in apps?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
Explain the relationship among Database, Tablespace and Data file?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
Oracle General 
