* Posts by shyamvaran

1 post • joined 24 May 2010

Oracle shows off M9000s for data warehousing


TPC-H and Compression?

It is interesting to note that booth the Oracle and IBM benchmarks did not use database compression. One would assume that for a DW type benchmark (TPC-H) database compression will help reduce the DB size and improve effective data scan rates. I can understand that Hybrid Columnar Compression (HCC) with potential of 10X compression cannot be used in non-clustered benchmarks as it is Exadata V2 only feature. Not sure how compression performs on the Sybase IQ side for such range of databases.




Biting the hand that feeds IT © 1998–2017