January 6, 2020 at 1:03 am
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
January 6, 2020 at 3:06 pm
I think this requires the In-Memory option, which is an additional license.
HTH
January 6, 2020 at 3:54 pm
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
January 7, 2020 at 8:07 pm
it has been pretty amazing for me to discover how few people know how little on issue(s) like this...
Likes to play Chess
January 7, 2020 at 8:28 pm
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