RE: Re : Losing out to SQL Server

> " In SQL Server, a table is basically a big linked-list and the data blocks
> are essentially the leaf-blocks of the cluster index. Those blocks are then
> doubly-linked back and forth so you can traverse the table in a full table
> scan or in an index range scan. In fact, an index range scan of the whole
> table is essentially (physically) the same as a full table scan. I'm not

A SQL Server table can be an unorganized heap just as in Oracle Databsase. See http://msdn.microsoft.com/en-us/library/ms188270(v=sql.105).aspx. A SQL Server "cluster index" is what Oracle calls an Index Organized Table. In other words, the table and the index become one.

> SQLServer 'Database' equates to a tablespace in Oracle, Darin Strait at

A SQL Server database is a unit of backup and recovery unlike an Oracle tablespace. Each SQL Server database within the SQL Server instance can be backed up and restored independently. It appears that Oracle 12c pluggable databases will be similar to SQL Server databases.

-- 
Iggy --
http://www.freelists.org/webpage/oracle-l Received on Sun Feb 17 2013 - 23:56:49 CET