If the order of rows in a table was truly random, the application
that uses that table would have to have random usage, and
you could NEVER get a clustering factor over keys in that table...
--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1084072587.374768_at_yasure...
> Roger S Gay wrote:
>
> >>>By definition the order of rows in a relational table is random.
> >>
> >>Also absolutely true.
> >>
> >
> > Howard, are you sure of this? Relational theorists please correct me if I am
> > wrong, but I thought the best we could say about the order of rows is that
> > it is indeterminate, which means we can't even make statistical arguments
> > based on assumed randomness.
>
> You are correct. The use of the word "random" is exactly what is the
> problem with much of this thread: It is imprecise. I know that both
Received on Sun May 09 2004 - 06:48:18 CDT
