Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> query optimization in different databases?

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@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 Wed Oct 01 2003 - 21:48:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US