Re: Informix vrs Oracle 7.0.x or 7.1.x

Alan Popiel writes: |> I have just completed Oracle 7 DBA training. I would like to offer the |> following comments comparing the data dictionary and optimizer of Oracle |> and Informix. |> |> 2. Oracle's data dictionary is rather more complete than Informix's. |> Oracle's DD contains many statistics that Informix DBAs must use |> tbstat, etc. to get. Check out the sysmaster database in 6.0. It includes all onstat (formally tbstat) info and more, and can be fully queried. This feature is also known as SMI (system monitoring interface) and allows you to code custom monitoring tools using esql/c, 4gl, etc. |> 3. Informix's cost-based optimizer is more advanced than Oracle's. |> However, Oracle's optimizer is being actively worked on and improved |> in each release. I don't know whether Informix's optimizer is |> receiving the same *concentrated* attention at this time. Now you know: Informix's optimizer is also being actively worked on and improved with each release. 6.0 sees the introduction of new statistic gathering capabilities and 7.0 new join mechanisms (which the optimizer must now take into consideration) as well as parallelism. I'd like to think we will maintain our more advanced placement relative to Oracle. Dave Disclaimer: The opinions expressed in this message are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. **************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney