Re: Comparison of DB2 and Oracle?

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 15 Nov 2004 21:22:32 -0800
Message-ID: <1a75df45.0411152122.2d957181@posting.google.com>

Why Oracle and not DB2? There are numerous sound technical reasons.

And this..

==

/home/billy/> sqlplus dataware_at_whs
SQL*Plus: Release 9.2.0.5.0 - Production on Mon Nov 15 15:27:06 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL> set timing on
SQL> select count(*) from x25_calls;

  COUNT(*)

---

 672839836

Elapsed: 00:00:35.18

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
==

Now anyone that have an idea what databases are about, will know what a SELECT COUNT entails, I/O wise.. and how critical table and index designs plays in optimising access and lowering I/O.

Can any other database, Open Source or commercial, come anywhere close to this? I doubt it.

And no, this nothing to do with hardware. The above was run against an old K-class HP-UX platform.

--
Billy

Received on Mon Nov 15 2004 - 23:22:32 CST