Question
What is a] RULE based optimization, b] COST based optimization ?
Answers
RULE based optimization USES A FIXED SET OF RULES to determine how to access the data.
COST based optimization USES STASTISTICS STORED IN THE DATA DICTIONARY WITH CERTAIN RULES to determine how to access the data.
Two modes - a] ALL_ROWS, B] FIRST_ROW. With the help of ALTER SESSION SET OPTIMIZER_GOAL = ALL_ROWS / FIRST_ROW, We can alter the modes of cost based optimizer.   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q Mohammadan Educational conference, which served as a common platform for meeting and spreading western education among the Muslims.
  • Q What are you expecting from McDonalds in the future?
  • Q How many times did Nick Faldo win the Masters golf tournament?
  • Q Sankaradeva was a religious reformer in:
  • Q How will you print 10 random numbers using foreach of java 8?
  • Q Can I Print a logo on an Invoice?
  • Q What is the maximum no. of columns a table can have ?
  • Q You need to dual-boot a computer with windows xp and windows me. You need all the partitions to be accessible from both the operating systems. Which file system would you use in this scenario?
  • Q What is COS?
  • Q What are some use of lua?
  • Q One Question Has Last Part Like Difference Between Two Terms Is 9 And Product Of Two Numbers Is 10, What Is The Squares Of Sum Of Numbers?