DA Morgan wrote:
Ignore it as much as you want, but in IDS (not needing Cheetah) it returns
immediately. As I wrote earlier, it makes an inplace ALTER. You can do
something similar, because when you add a column it won't physically change or
visit all the table blocks... right? With the default the same happens... why?
because, if the column wasn't there, than the column value was evidently NULL
and so, if you select a previous row it will return the DEFAULT.
Go on... give Larry a call and ask for it, or confirm if it's in 11g... My
fellow Orace DBAs would pay for it more easily than they'd pay for flashback or
RAC.

So, your statement should be "It doesn't IN ORACLE". I remove the part "it
WON'T IN ORACLE" because i believe sometime they'll catch up.

I think it's my time now to step off this thread. I'm tired of having to write
2 or 3 posts to make you admit your errors and false statements. I easily admit
and don't mind to repeat here, that there are several features in other
databases that I'd like to see implemented in IDS. A few of us even know I've
done my best to influence their implementation. That's simply because I'd like
to see more functionality on top of what I think it's a very good RDBMS. The
lack of some features don't change my current opinion, and the fact that I see
it being used with success in very demanding conditions, with very low
maintenance (aka DBAs time).

It's been nice to check some features in Oracle, and learn a bit more about it,
but it's enough... If I need more I'll check the Internet... It's less tiring
than pointing your mistakes.

Regards.

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

DA Morgan wrote:
without. Because the default DEFAULT is NULL. It's just another
constant. There is no need to visit anything more than the meta data.

IBM has been using this "technology" since before I joined 10 years ago.
(Gee.. I'm getting old). Anyway don't you guys think this thread is
getting abit lengthy. You'll wreck Mark T.s beautyfull statistics and
Daniel is most certainly on his path to "all time top poster" ;-)

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Serge Rielau said:
And that would mean war ... >)

--
Bye now,
Obnoxio

"I'm astonished anyone pays real money for this crap."
-- Cosmo

--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.

Amen, can we put this bloody horse under the pasture?

Fernando Nunes wrote:
I'll check it out. But I must confess the last time I had to do this in
a production database was ... let me see ... well never. But it is
interesting. Thanks for the tip.

And lets kill this thread before I become a regular. ;-)
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)

DA Morgan wrote:
Too Late ;-)

-----Original Message-----
From: informix-list-bounces (AT) iiug (DOT) org
[mailto:informix-list-bounces (AT) iiug (DOT) org] On Behalf Of DA Morgan
Sent: 05 July 2007 08:35 PM
To: informix-list (AT) iiug (DOT) org
Subject: Re: Informix beats Oracle

Dirk Moolman wrote:

My collegues are still comparing IDS 7 with Oracle 10G - completely not
fair

:-/


*** Disclaimer ***

The information contained in this e-mail is confidential and legally privileged and is intended solely for the addressee and to others who have the authority to receive it. Access to this e-mail by anyone else is unauthorized and as such, any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. If you have received this e-mail in error, please notify the sender immediately.

The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of the Company.

The Company is not liable to ensure that outgoing e-mails are virus-free.

The Company is not liable, should information or data, for whatever reason, be corrupted or fail to reach its intended addressee.

The Company is not liable for any loss or damage of whatsoever nature and howsoever arising resulting from the opening or the use of the information in this e-mail, including its attachments and links.

The sender of this e-mail is subject to and bound by the terms and conditions of Company+IBk-s Electronic Communications Usage Policy.

Dirk Moolman wrote:
Ask them about online backups . .. (snicker) . .

JWC

John Carlson wrote:

And you will discover that in the current millenium they can be
performed, easily, with all major commercial RDBMS products.

Snicker indeed.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)