Re: Oracle pricing ain't going down

Really? I'm curious, because after reading up on Index-Organized Tables, they sound actually pretty similar.

Clustered Index: an "ordering ruleset" for the data on the disk. IOT: a method to store oracle rows in a b*Tree format instead of the default rowid-controlled heap.

So, generically, both are ways you can control the physical order of the data on your disk. Is there more to it than this simplistic explanation?

Followup question: why not have EVERY table be an IOT in oracle?

(notwithstanding the known limitations of IOTs; no longs, no clustering)

Boss

>
> IOT and clustered indexes are not comparable to each other.
>
> -----Original Message-----
> Sent: Friday, October 24, 2003 2:44 PM
> To: Multiple recipients of list ORACLE-L
>
>
> My workplace is going in the same direction as David Mitchell's. Our
> OLTP systems are Oracle, basically everything else is being (or being
> considered) migrated to MSSQL2000.
>
> I am not that familiar with SQL Server, but I believe SQL2000 has
> sequences. I think MS calls it identity. I think MS also has IOT, which
> they call clustered indexes. MS might even have function based indexes
> with SQL2000, but not very sure. Anyone care to comment?
>
> Abey.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, October 23, 2003 11:19 PM
>
>
> > > -----Original Message-----
> > > From: Ryan [mailto:rgaffuri_at_cox.net]
> > > Sent: Friday, 24 October 2003 12:44
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: Oracle pricing ain't going down
> > >
> > >
> > > what is MSEE lacking in?
> >
> > <sound of can of worms opening>
> >
> > Here's a start. MSSQLServer EE has ...
> >
> > No bitmap indexes, no partitioned indexes, no function-based indexes,
> > no
> domain indexes, no reverse key indexes, no object tables, no before
> triggers (can be kludged, not pretty), no multiple actions per trigger
> event, no 3rd-party language support a la Oracle's JVM and pro*...
> modules, no built-in OLAP (it's a weird bolt-on), no control over extent
> size, no control over block size, no star query optimisation, no
> sequences, no synonyms, no packages, no structured exception handling in
> stored proc language (TSQL), no MINUS union operator, no multiplexing or
> mirroring of log files, no cyclical log management, no escalation-free
> locking, no index organised tables.
> >
> > (Working with both every day, do you get the feeling I've been asked
> > this
> before? :-))
> >
> > Half of those things are available in Oracle SE One :-)
> >
> > Ciao
> > Fuzzy
> > :-)
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Grant Allen
> > INET: Grant.Allen_at_towersoft.com.au
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the
> > name of mailing list you want to be removed from). You may also send
> > the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Abey Joseph
> INET: abey9800_at_hotmail.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from). You may also send the HELP
> command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rothouse, Michael
> INET: mrothouse_at_fcg.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Todd Boss
  INET: boss_at_i-sphere.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).