Search

Top 60 Oracle Blogs

Recent comments

Home

Zone Maps

12.1.0.2 Introduction to Zone Maps Part III (Little By Little)

Submitted by Richard Foote on Mon, 2014-11-24 06:16

I’ve previously discussed the new Zone Map database feature and how they work in a similar manner to Exadata Storage indexes. Just like Storage Indexes (and conventional indexes for that manner), they work best when the data is well clustered in relation to the Zone Map or index. By having the data in the table […]

12.1.0.2 Introduction to Zone Maps Part II (Changes)

Submitted by Richard Foote on Thu, 2014-10-30 06:45

In Part I, I discussed how Zone Maps are new index like structures, similar to Exadata Storage Indexes, that enables the “pruning” of disk blocks during accesses of the table by storing the min and max values of selected columns for each “zone” of a table. A Zone being a range of contiguous (8M) blocks. I […]

12.1.0.2 Released With Cool Indexing Features (Short Memory)

Submitted by Richard Foote on Fri, 2014-07-25 06:18

Oracle Database 12.1.0.2 has finally been released and it has a number of really exciting goodies from an indexing perspective which include: Database In-Memory Option, which enables specific portions of the database to be in dual format, in both the existing row based format and additionally into an efficient memory only columnar based format. This in […]