Re: Comparison of DB2 and Oracle?
Date: 16 Nov 2004 07:45:17 -0800
Message-ID: <d2a59601.0411160745.3d850467_at_posting.google.com>
what a dork...
Pete H
vslabs_at_onwe.co.za (Billy Verreynne) wrote in message news:<1a75df45.0411152122.2d957181_at_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.
Received on Tue Nov 16 2004 - 16:45:17 CET