Skip to content

SQLMDX

Eventually it's all about data

  • About
  • Contact

Blogroll

  • Database Whisperers
  • Frits Hoogland
  • Jonathan Lewis
  • Miladin Modrakovic
  • Sayan Malakshinov
  • Tanel Poder

Categories

  • Oracle
  • Perl
  • PowerShell
  • Python
  • R
  • Scala

Archives

  • May 2020
  • April 2020
  • March 2020
  • July 2016
  • May 2016
  • March 2016
  • December 2015
  • October 2014
  • September 2014
  • May 2014
  • December 2013
  • November 2013
  • March 2011

Tags

12c 10053 built-in packages CBO differentiation domain indexes Extensible Indexing Extensible Optimizer external procedures internals materialized views OLAP parallel execution partitioning performance tuning regular expressions sqlplus sql trace transformations

materialized views

Query rewrite in Oracle

Query rewrite an one of Query Transformations which makes possible to use materialized view to get results instead of querying underlying tables.

Basic prerequisites for query rewrite described in corresponding chapter of a Database Data Warehousing Guide. Let’s start with a simple example to show how it works.

Continue reading →

Comment
May 5, 2020May 24, 2020 sqlmdx
materialized viewstransformations
Create a website or blog at WordPress.com