Search

OakieTags

Who's online

There are currently 0 users and 37 guests online.

Recent comments

Affiliations

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

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:     [...]