Re: Differences between the Microsoft and the Oracle SQL server

In article <4qtdoc$gqd_at_inet-nntp-gw-1.us.oracle.com>, "an133911_at_anon.penet.fi" <an133911_at_anon.penet.fi> writes
>> What features does Oracle offer than Informix OnLine XPS Entended
>>Parallel Server does not?
>
>Well lets see . . .
>OLTP features such as triggers, stored procedures, declarative
>referential integrity. These won't be added to the product until a
>future release. Informix uses partitioning to achieve parallelism in
>queries. Informix does not perform well when data is not partitioned
>and with their 8.0 system that you mentioned above, they are unable to
>achieve ANY parallelism at all without partioning.

  Wrong,Wrong,Wrong Informix does have triggers,stored procedures and referential integrity. It does not use just partitioning to acheive parallelism in queries - it uses multiple threads per query if PDQ is enabled. E.g.

   SELECT x,y

      FROM z
      GROUP BY x
      ORDER BY y

  gets possibly >1 scan thread, a group by thread, a sort thread...   If you use the OnPerf GUI performance monitoring tool you can see each   thread and how many rows it has processed so far... I've seen it   running!   

>Drawbacks of their Static partitioning:
>Inflexible - can't achieive parallelism without partition

   Prove wrong above.

>Parallelism or administration - but not both. You can either
>partition data for performance (parallelism) or partition for
>administration. However you can't partition for BOTH performance and
>administration. With Oracle partitioning isn't necessary. Informix

                               ^
                               |

  Really so how do you control disk layout to ensure that disks/controllers can be used in parallel. Less i/O bandwidth means lower performance and how do you acheive that in Oracle??

>Partioning is done MANUALLY. There are no partioning tools. Data
>distribution changes require repartitioning, schema shcanges require
>repartitioning, and ALL THIS MEANS DOWNTIME! Show me some Informix

   Never really need tools to do paritioning - I've always been able to    write scripts...    

   Data distibution changes do not always require repartitioning. Only    if it means that parallelism across disks suffers and you HAVE to    redo your layout of data across disks if that happen. Don#t tell me    ORACLE KNOWS whne the system is idle can which queries users run    frequently and can reod the disk layout when the system is idle...    Hmmm I know that no users will be running queries for the next 1/2 hr    I'll just redistibute my data...... Oracle Future Prediciton Add-on    module is here at last....

>sites with more than 200 gb in size - RARE!

  K-MART evualuate all the leading relational daabases for thier new   600GB data wharehouse and decided.....Informix.   

> Unproven OLAP- they don't
>even offer a multidimensional database or analysis.
>

    Informix do have a multidimensional analysis tool - MetaCube.         

>I could go on and on - Informix days are over. Let me give you an
>example... the technology you mentioned above - its latest web page
>from Informix is from JULY 1995!!!!! HELLO INFORMIX PULL YOUR HEAD
>OUT and start producing and stop talking! Just for proof -
>http://www.informix.com/informix/corpinfo/zines/whitpprs/wht3/6828whi.htm
>. . . pathetic.

   Whats so pathetic - sounds better than Oracle to me - sa share    nothing rather than a share everything system.  

>Oh, and what about raw bottom-line speed - once again Oracle kicks
>Informix all over on any platform!!!!
>

    Prove it - on a platform with the same number of CPUS running     at the same speed with the same amount of memory and disks     i.e. the same hardware. Go no prove it on >3 platforms.

>
>> From an Informix guru.
>>--
>>David Williams
>
>If I were you David, I'd be looking around for another job - and we
>both know it!
>

   If I were you I'd

1. get your facts right... the URL you quote actually proves Informix supports triggers and stored procedures....blown your candle out without even trying!

   Please do go on - anything else than Oracle has you think Informix    does not have?

-- 
David Williams