Oracle Database Discussions

The testing include environment setup,
data loading, query and tuning.
We can beat Sybase IQ for data loading and index,
but the query performance is poor.

LOAD + INDEX:
Sybase IQ, Oracle
1330s, 1206s

QUERY:
Sybase IQ, Oracle
35s, 600s

There are 46M records and 6G storage in a CDR table.
The SQL statement like:
Select called, cf, count(*), sum(cduration) from upcdr04122408 group by called, cf order by called, cf;

SELECT RTRIM(caller), cf,COUNT(*),SUM(cduration/1000.0) FROM upcdr04090809
WHERE(( caller LIKE '139%') )
GROUP BY RTRIM(caller), cf ORDER BY RTRIM(caller), cf


The Sybase IQ is not a traditional RDBMS, the engine is dedicate for DW. It's claim that the IQ can devliver ad hoc query performance up to 100 times faster than traditional RDBMS. But we can found in the tpc.org, we beat Sybase IQ in TPC-H benchmark.
Maybe we can find a tuning expert to do the further tuning.

I'm trying,
1) MV
2) BitMap index
3) dbms_advanced_rewrite (add more extracted column, such as substr(call_num,1,3) )
--or store outline
4) Compress TABLE/INDEX
5) Partition

Thx, Zhu1