Re: query optimization in different databases?
From: AK <ak_tiredofspam_at_yahoo.com>
Date: 6 Oct 2003 20:10:28 -0700
Message-ID: <46e627da.0310061910.ecf8c05_at_posting.google.com>
Date: 6 Oct 2003 20:10:28 -0700
Message-ID: <46e627da.0310061910.ecf8c05_at_posting.google.com>
I'd say the difference is not as dramatic as you put it. I would say Oracle and SQl Server are approximately 3, at most 4 years behind DB2 in optimizer's capabilities. Maybe it's just 2 years.
Also Oracle leaves a very large footprint, and MS SQL Server cannot be more reliable than the only flaky operating system it runs on.
That's it. For almost all common tasks, either one of these RDBMS is a good choice. If you need 24/7, don't consider MS SQL Server. Received on Tue Oct 07 2003 - 05:10:28 CEST