jump to navigation Released With Cool Indexing Features (Short Memory) July 25, 2014

Posted by Richard Foote in 12c, Advanced Index Compression, Attribute Clustering, Database In-Memory, Zone Maps.

Oracle Database 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 turn enables analytical based processing to access the real-time data in the In-Memory Store extremely fast, potentially faster and more effectively than via standard analytical based database indexes.
  • Advanced Index Compression, which allows Oracle to automatically choose the appropriate compression method for each individual leaf block, rather than having to manually select a single compression method across the whole index. This makes compressing an index a breeze and much more effective than previously possible.
  • Zone Maps, which enables Storage Index like capabilities to be manually configured and physically implemented inside the database, to eliminate unnecessary accesses of table storage via much smaller objects than conventional database indexes.
  • Attribute Clustering, a new table attribute which enables much better clustering of table data and we all know how both compression and index structures love table data to be well clustered.

These are all topics I’ll be covering in the coming weeks so stay tuned :)

About these ads


1. fidelinho - July 25, 2014

I also saw the advance index compression, interesting. I assume it also needs an ACO license, could not find information (but I did not look much for it)

Richard Foote - September 3, 2014

Yes it does. You can find this sort of information in the Licensing Information manual.


2. Arvind Pandit - September 1, 2014

Wow that was unusual. I just wrote an really long
comment but after I clicked submit my comment didn’t show up.
Grrrr… well I’m not writing all that over again. Anyways, just wanted
to say fantastic blog!

3. conceive naturally - September 13, 2014

Pretty section of content. I simply stumbled upon your weblog and in accession capital to claim that I acquire in fact loved account your blog posts.
Anyway I will be subscribing on your augment or even I
fulfillment you get right of entry to constantly rapidly.

4. http://my.telegraph.co.uk/members/emilmcbride/profile/ - September 15, 2014

whoah this weblog is great i love reading your articles. Keep up the good work!
You recognize, many people are hunting around for this information, you can aid them greatly.

5. http://glskating.com/groups/fast-methods-for-adult-porn-videos-explained/ - September 16, 2014

You really make it seem so easy with your presentation but
I find this matter to be actually something which I think I would never understand.
It seems too complex and extremely broad for me. I’m looking forward for
your next post, I will try to get the hang of it!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Get every new post delivered to your Inbox.

Join 1,861 other followers

%d bloggers like this: