• Star Transformation « Oracle Scratchpad
  with optimization oracle oracle11g schema scratchpad star transformation
• Theory of Constraints
  The Theory of Constraints takes a scientific approach to improvement. It hypothesizes that every complex system, including manufacturing processes, consists of multiple linked activities, one of which acts as a constraint upon the entire system (i.e. the constraint activity is the “weakest link in the chain”).
  with bottleneck constraint constraints improvment process production theory
• Using TUNE_MVIEW and EXPLAIN_REWRITE to enable us to tune MV Fast Refreshes and Query Rewrites
  Use 11g packages in DBMS_MVIEW to see how the SQL query transformed or rewritten to use materialized view instead
  with and dbms_mview explain_rewrite materialized mv tune_mview view views

Bookmarks 21 - 23 « Previous