RE: Oracle pricing ain't going down

"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).