I realized in my hasty response that I failed to complete my thought/question. My response should have been:
IOT and clustered indexes are not comparable to each other. Are they? As you mention, by definition they do appear similar. I originally thought more about how they are used as it appears (from my experiences anyway) that clustered indexes are utilized more frequently in SQL Server/Sybase than IOTs in Oracle. I too am curious as to when it is an advantage or disadvantage to utilize an IOT. I read somewhere that IOTs are best suited for lookup tables. Tables with a large number of columns are not a very good IOT candidate. I'm just not experienced enough in understanding why that is. -----Original Message----- Sent: Friday, October 24, 2003 7:14 PM To: Multiple recipients of list ORACLE-L 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" <[EMAIL PROTECTED]> > Sent: Thursday, October 23, 2003 11:19 PM > > > > > -----Original Message----- > > > From: Ryan [mailto:[EMAIL PROTECTED] > > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).