Re: A question for Mr. Celko
From: Jan Hidders <jan.hidders_at_REMOVETHIS.pandora.be>
Date: Mon, 19 Jul 2004 22:32:32 GMT
Message-Id: <pan.2004.07.19.22.33.12.681221_at_REMOVETHIS.pandora.be>
>> That approach rests upon two assumptions: (1) you have enough useful
>> algebraic identies for optimizing and (2) the algebraic expression
>> corresponds roughly to a real query evaluation plan. For the PACK and
>> UNPACK operators I haven't seen much proof for (1) and (2) seems
>> doubtful since they don't look operators you would directly implement
>> that way.
Date: Mon, 19 Jul 2004 22:32:32 GMT
Message-Id: <pan.2004.07.19.22.33.12.681221_at_REMOVETHIS.pandora.be>
On Mon, 19 Jul 2004 12:02:23 -0700, John Jacob wrote:
> Jan Hidders <jan.hidders_at_REMOVETHIS.pandora.be> wrote in message > news:<pan.2004.07.18.13.17.46.586491_at_REMOVETHIS.pandora.be>...
>> That approach rests upon two assumptions: (1) you have enough useful
>> algebraic identies for optimizing and (2) the algebraic expression
>> corresponds roughly to a real query evaluation plan. For the PACK and
>> UNPACK operators I haven't seen much proof for (1) and (2) seems
>> doubtful since they don't look operators you would directly implement
>> that way.
> > I have to admit I haven't spent much time thinking about the actual > implementation, but I have to disagree that the primitives aren't there.
??? Where did I say that the primitives aren't there?
- Jan Hidders