At 08:41 AM 7/2/01 -0700, Steve Landrum wrote:

>I guess this is the application developer part of me comming
>to the surface trying to dumb proof the process.
>
>If the person doing the backup can specify the sort fields
>in a backup file and chooses to sort an unindexed field wouldn't
>this mean the database would have to sort the entire table in temp
>files?
>

Yes, but presumably the command language that specified the
backup would reference the index to the "clustered" by index
name, not field name(s).

Jim Starkey