"IDENTITY" does not have exactly "SEQUENCE" functionality. It is a property, you can assign to a column. And it has "buggy" implementation, I've seen duplicate values (not sure about the latest version). So be careful with this feature.
As for "clustered indexes" - you are correct. Actually SQL Server (Sybase) had them before Oracle implemented IOTs. Igor Neyman, OCP DBA [EMAIL PROTECTED] -----Original Message----- Abey Joseph Sent: Friday, October 24, 2003 1: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: Igor Neyman 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).