Re: Views- Advantages and Disadvantages

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 05/09/07 20:21, Dann Corbit wrote:
>> -----Original Message-----
>> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
>> owner(at)postgresql(dot)org] On Behalf Of Ron Johnson
>> Sent: Wednesday, May 09, 2007 6:07 PM
>> To: pgsql-general(at)postgresql(dot)org
>> Subject: Re: [GENERAL] Views- Advantages and Disadvantages
>>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> On 05/09/07 15:18, Dann Corbit wrote:
>> [snip]
>>> That is a significant achievement, since many database systems do
> not
>>> have that ability.
>> Maybe (probably!) back in the Oracle 6 days, but cost-based
>> optimizers have done this for *years*.
>
> I work mostly with legacy database systems, so I am surely behind the
> times here.

As do I, but it (Rdb/VMS) has had a CBO for 20+ years.

(Oracle bought Rdb/VMS from DEC back in 1994, and I know for certain
that a lot of the Rdb engineers were transferred straight into the
RDBMS engineering group.)

- --
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGQnYVS9HxQb37XmcRAjODAKCoiEXClQ9PyWT9sEGfn21qbRvRfwCgnXYM
oYUrnVBwuSadIJfDDEDln2I=
=i2pZ
-----END PGP SIGNATURE-----