Columnstore index to be created in Oracle

  • VoldemarG

    Hall of Fame

    Points: 3571

    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.


    Voldemar
    likes to play chess

  • Nice Marmot

    SSCrazy

    Points: 2257

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

    HTH

  • VoldemarG

    Hall of Fame

    Points: 3571

    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 ?


    Voldemar
    likes to play chess

  • VoldemarG

    Hall of Fame

    Points: 3571

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


    Voldemar
    likes to play chess

  • Sue_H

    SSC Guru

    Points: 90544

    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 5 (of 5 total)

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