Re: 100.000 $ Reward (Oracle 8 versus SQL 7)

Okey dokey:

Using Oracle8.1 as a reference:

1. SELECT statements with a function applied to the WHERE clause will use an index (with no modification of syntax) if (all other parameters held constant and suitable) the index is created on the function of the column rather than the column itself. SQLServer7 can't do that.
2. The cost-based optimizer will determine which index(es) to use or whether to do full table scans. With bitmap indexes, the CBO can do unions and intersections of the indexes to get the necessary row ID's to retrieve. SQLServer7 can't do that.
3. Speaking of bitmap indexes, SQLServer7 doesn't have them. Only B-tree indexes are available.
4. Oracle can automatically perform partition-elimination on partitioned tables and partitioned indexes. SQLServer7 can't do that. In fact, SQLServer7 doesn't support any form of partitioning.
5. Oracle provides summary management, which allows a query directed at a large fact table to be transparently redirected to a much smaller summary table, completely behind the scenes with no modification in SQL syntax. SQLServer7 can't do that.
6. (Just for good measure) Oracle recognizes dimensional models (ie. "star schemas") if they are designed correctly, and will automatically use "star join" processing algorithms rather than more traditional relational algorithms. SQLServer7 can't do that.

If you don't buy any of this, check the benchmarks on www.tpc.org and/or the documentation on technet.oracle.com.

Email me and I'll reply with the mailing address you can send the $100,000 check to. :=)

Best regards,

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original modern rock? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

Dan G wrote in message <7qoogi$h44$1_at_pollux.ip-plus.net>...
>Check this out first !:
>http://www.dbpd.com/vault/9801xtra.htm
>
>Second: I am not an Microsoft fan (even if I am using MS SQL).
>
>Allmost all Oracle commandments (applicable to SQL 7) doesn't need to be
>applied with SQL 7 because the query optimizer is smart enough.
>Allmost all Oracle enhancemets (written in the article) apllied as well
with
>SQL 7.
>The one who can give more than 5 examples against the above statements
worth
>the prize ;-).
>
>All the best.
>
>
>
>
>
Received on Tue Sep 07 1999 - 21:43:16 CDT