Re: Oracle pricing ain't going down

Identity has come a LONG way in Sybase since its initial introduction back in Sybase v10.0 (1994). In fact, the latest versions of Sybase have identities tuned almost to where they emulate a monotonically increasing sequence in every capacity (if you set the parameters correctly).

I've never seen duplicate values with it though. The most common complaint is with "gaps" in the assigned values (since Sybase caches large chunks of numbers to pre-use, and loses them upon abnormal shutdowns). However, there's remedies even for that situation. (see http://www.sypron.nl/idgaps.html for a great writeup).

Surf to http://www.isug.com/Sybase_FAQ/ASE/section6.2.html#6.2.9 for more information. That's the direct link to the Identity section of the Sybase FAQ ... its a little dated but most of the info is still valid. I actually wrote this "answer" for the Sybase FAQ back in 1997 (so yes i know what i'm talking about, i think. :-) )

Todd Boss (a true Sybase dba now hanging out in an oracle world).

>
> "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
> ineyman_at_perceptron.com
>
>
>
> -----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" <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: Igor Neyman
> INET: ineyman_at_perceptron.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).