>David,
>
>One thing you need to consdier is the difference between local data systems and client/server systems. Basically, you don't ever want to get all 3,000,000 records. You want to give the user an interface that allows them to specify what they need and then get only the records that meet the user's request.
>
>Yes, you can index a view but only in record oriented buffering not in table buffering.
>
>So, if your view is named MyView and it gets opened in table buffering you can;
>
>

>SELECT MyView
>LOCAL lnOldBufferMode
>lnOldBufferMode = CursorGetProp("BUFFERING","MyView")
>CursorSetProp("BUFFERING",5,"MyView")
>INDEX ON ...
>
>CursorSetProp("BUFFERING",lnOldBufferMode,"MyView")
>

I understand the difference between file system and C/S. I have an app that I want to convert to SQL Server 7 and would like to minimize the amount of conversion coding.
Thanks!