Columnstore index to be created in Oracle

• VoldemarG

  Hall of Fame

  Points: 3883

  More actions

  January 6, 2020 at 1:03 am

  #3712511

  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

• Nice Marmot

  SSCrazy

  Points: 2278

  More actions

  January 6, 2020 at 3:06 pm

  #3712669

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

  HTH

• VoldemarG

  Hall of Fame

  Points: 3883

  More actions

  January 6, 2020 at 3:54 pm

  #3712701

  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

• VoldemarG

  Hall of Fame

  Points: 3883

  More actions

  January 7, 2020 at 8:07 pm

  #3713381

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

  Likes to play Chess

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  January 7, 2020 at 8:28 pm

  #3713388

  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