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?

Steve Landrum

At 11:25 AM 7/2/01 -0400, you wrote:

>At 08:13 AM 7/2/01 -0700, Steve Landrum wrote:
>>
>>My vote is for an extension to the system tables to force the
>>use of an index on the sorted fields and to not change the
>>backup restore process.
>>
>
>Huh? What sorted fields? Why do you need to force an index on anything
>when someone can declare one?
>
>Jim Starkey
>
>To unsubscribe from this group, send an email to:
>IB-Architect-unsubscribe@onelist.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>