Can a Columnstore index be created in Oracle

• VoldemarG

  Hall of Fame

  Points: 3883

  More actions

  January 4, 2020 at 1:35 am

  #3712289

  Can a Columnstore index be created in Oracle a regular, non memory optimized table?

  Just like it is possible to do in SQL Server.

  Likes to play Chess

• frederico_fonseca

  SSCoach

  Points: 16158

  More actions

  January 4, 2020 at 12:24 pm

  #3712355

  yes.... at a high cost mind you.

  see https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/use-hcc-this-service.html

  and https://logicalread.com/2013/06/17/oracle-11g-hybrid-columnar-compression-mc02/

  not for all versions of oracle

  • This reply was modified 4 years, 11 months ago by  frederico_fonseca.