Search

OakieTags

more tags

Who's online

There are currently 0 users and 26 guests online.

Recent comments

Affiliations

Home

Oracle Bugs

11g Virtual Columns and Fast Refreshable Materialized Views (What In The World)

Submitted by Richard Foote on Wed, 2010-11-24 13:09

Previous to Oracle 11g Rel 2, two very common and useful features previously worked well together, they being fast refreshable materialized views and the introduction of virtual columns due to the creation of function-based indexes.   To illustrate, we create and populate a little demo table:    We now create a simple little function-based index:     [...]