| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.theory -> table types
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 - 11:53:04 CDT
 |
 |