Re: Oracle pricing ain't going down

'identity' is not the same as a sequence.

An identity column is a self incrementing column for use as a PK. As it's only use is to increment a column value, it is not quite as powerful as a sequence.

Jared

On Fri, 2003-10-24 at 11:44, Abey Joseph wrote:
> 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: Jared Still
  INET: jkstill_at_cybcon.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).