Re: Pizza Example

From: Jan Hidders <>
Date: Sun, 18 Apr 2004 11:19:30 GMT
Message-ID: <6vtgc.75876$>

Anthony W. Youngman wrote:
> In message <h2jdc.64877$>, Jan Hidders
> <> writes

>> Dawn M. Wolthuis wrote:
>>>  So, if "the Pizza has Mozzarella and Parmesan cheese" is stored as:
>>>  Pizza  Mozzarella
>>>           Parmesan
>>>  in a single, uh, record, then if the ordering is unwittingly useful, we
>>> didn't harm that ordering.
>> Indeed, but you did make certain query-optimizations impossible. Never 
>> mind that what you are advocating is basically sloppy data modelling.

> What optimisations?

Certain join reorderings. Joins on lists are not commutative.

> Okay, Pick forces more stuff into the conscious
> design of the db programmer, but an index on cheese and I don't see what
> queries can't be optimised.

That doesn't surprise me.

  • Jan Hiddesr
Received on Sun Apr 18 2004 - 13:19:30 CEST

Original text of this message