table types
From: Marshall Spight <mspight_at_dnai.com>
Date: Wed, 21 Jul 2004 16:53:04 GMT
Message-ID: <QbxLc.134446$a24.10043_at_attbi_s03>
From the benchmarks I've seen over the years, it seems like the two most "generally fast" dbms are Oracle and MySQL, where "generally fast" doesn't really mean anything if you look closely but you all know what I mean anyway.
Date: Wed, 21 Jul 2004 16:53:04 GMT
Message-ID: <QbxLc.134446$a24.10043_at_attbi_s03>
From the benchmarks I've seen over the years, it seems like the two most "generally fast" dbms are Oracle and MySQL, where "generally fast" doesn't really mean anything if you look closely but you all know what I mean anyway.
MySQL uses bags of records, and the only join execution plan it can do is nested loop. (I would imagine there would be a nice merge-join case that Oracle could kick MySQL's behind on.)
Anyone know what in-memory layout Oracle uses? (roughly) How prevalent is the inverted index? And why isn't everyone using it?
Marshall Received on Wed Jul 21 2004 - 18:53:04 CEST