Re: Oracle and PICK
Date: 20 Apr 2004 02:36:46 -0700
Message-ID: <c0e3f26e.0404200136.40256f5f_at_posting.google.com>
"Dale Benedict" <dalebnospam_at_spamnotwantedflightcraft.ca> wrote in message news:<RMZgc.51742$aD.38523_at_edtnps89>...
> "Tony" <andrewst_at_onetel.net.uk> wrote in message
> news:c0e3f26e.0404170953.cf441f0_at_posting.google.com...
> > ross_at_stamina.com.au (Ross Ferris) wrote in message
> news:<26f6cd63.0404170656.72605341_at_posting.google.com>...
> >
> > This is logical/physical confusion. The fact that invoice headers and
> > lines logically reside in 2 separate tables does not mean that they
> > may not physically reside together on disk for performance reasons.
> > Oracle, for example, allows 2 or more tables to be physically
> > "clustered" together by key values.
>
> I think you missed something here. Within Pick it is possible to have the
> all header and all detail lines reside in the same physical record on disk!
Not at all. My point was that in Oracle (for example), you can have the header and all its detail lines reside in the same physical record on disk too! That is what clustering is for. Received on Tue Apr 20 2004 - 11:36:46 CEST