Re: Informix vs Oracle vs DB2. SQL Query optimization.

> The fact that Mark said that the spatial data types are now no longer > a derived data type doesn't make things look better for Oracle's > spatial. Also it doesn't make sense. I seem to recall that talking > with DBAs that you got Oracle spatial as part of Enterprise Edition, > but not with the other editions. Of course some of the confusion is > that these Oracle DBAs have been working with Oracle for years and as > Mark points out. It wasn't until a recent release that they are now > native. > Is that 11 or 10g? Gumby - you are confused. I said that Spatial was not a data cartridge, and that it was part of the kernel. For spatial, this was always the case, as it predated cartridges. I don't know what a derived data type means in this context. In terms of licensing, Spatial is an option to Enterprise Edition, however basic location capabilities are available with all editions.