-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 05/09/07 20:21, Dann Corbit wrote:
>> -----Original Message-----
>> From: [EMAIL PROTECTED] [mailto:pgsql-general-
>> [EMAIL PROTECTED] On Behalf Of Ron Johnson
>> Sent: Wednesday, May 09, 2007 6:07 PM
>> To: pgsql-general@postgresql.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-----
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
