Re: Recreate Table With Sorted Data

[Michael Dykman]

> >Question 2: If not, what would the Insert/Select statement look like that
> would copy the records over in sorted order?
>
>
> Tables aren't sorted. Period.
>
>
>
> Only result-sets can be sorted.

While that is true, strictly speaking, packing data into the same
physical order as you expect to logically access it is a fairly common
optimization for data which remains fairly static.  Having said that,
for the 1600 records reffered to here, I doubt there would be any
observable difference.



-- 
 - michael dykman
 - mdykman@stripped

 - All models are wrong.  Some models are useful.