Re: Loading optimization

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