Columnstore index to be created in Oracle

  • Does Oracle allow creating a Columnstore index be created on a regular, non memory optimized table?

    Just like it is possible to do in SQL Server.

    Likes to play Chess

  • I think this requires the In-Memory option, which is an additional license.

    HTH

  • This is what I figured, too. Just wasn't sure..

    So with that being said, can we assert that MS SQL Server had now an ADVANTAGE over Oracle in Columnstore technology usability/flexibility compared to Oracle, since In-Memory is NOT required in SQL Server in order to clreate Columnstore indexes on any qualifying table ?

    Likes to play Chess

  • it has been pretty amazing for me to discover how few people know how little on issue(s) like this...

    Likes to play Chess

  • Not really an advantage, they are very different, useful for different use cases. Oracle also has hybrid column compression (which is "on disk") in addition to in-memory column store. HCC also has different types of compression depending on it's usage.

    Sue

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply