Gary Wesley wrote:
> Is there any advantage to having data sorted before populating it into a
> table?
> (In 6.5)
>
> Gary Wesley
Yes. You have effectively loaded it with a clustered index. If you
cluster an index on the sort column after loading it, the sort will remain
in effect and will speed queries/joins that use that column.
Ian