query optimization in different databases?
From: Ryan <rgaffuri_at_cox.net>
Date: Wed, 1 Oct 2003 22:48:49 -0400
Message-ID: <hmMeb.37952$0Z5.7799_at_lakeread03>
how different are the optimizers between the different commercial databases? Will a query written one way from one vendor not run as well under a different vendor?
Date: Wed, 1 Oct 2003 22:48:49 -0400
Message-ID: <hmMeb.37952$0Z5.7799_at_lakeread03>
how different are the optimizers between the different commercial databases? Will a query written one way from one vendor not run as well under a different vendor?
Also, Im familiar with Oracle and I know that physical I/Os are generally not considered much of a problem(its a small piece of the pie). Typical you focus on decreasing logical I/Os. I am reading an academic database book that states that physical I/Os are extremeley important. Is this the case with databases created by other vendors?
Received on Thu Oct 02 2003 - 04:48:49 CEST