Re: SQL vs. Oracle

From: Daniel <delj_at_flash.net>
Date: 27 Jan 2000 11:42:21 EST
Message-ID: <86pshd$9ae@journal.concentric.net>

I use both... have major issues with both... Oracle is indeed more robust, but at least SQL 7.0 knows to use an existing index when it optimizes a query. My last project for Oracle 8 included a database which was set to default for cost optimization. There were instances where a simple 2 table inner join refused to use indexes, performed a full table scan and needed a hint to work properly. I'm keeping my customers away from 8 until I can count on the optimizer.

Daniel
Austin, TX

> But don't worry: as soon as M$ releases SQL 10.0, all that will be
> fixed and ORACLE V7 will face some real competition. In the NT
> platform.
>
>
> Cheers
> Nuno Souto
> nsouto_at_nsw.bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
Received on Thu Jan 27 2000 - 10:42:21 CST