Hi.

I have 2 remote views that are both bringing down potentially millions of rows from 2 different database tables. I need to put indexes on these views but when I use the command..

INDEX ON remove_view_name index_expression

..Windows seems to like to create these huge temporary files in the docsandsetting/username/localsetting/temp folder. I suppose these temporary files are housing the indexes in some way but is there a way to do indexing on "large" remote views that doesn't take up so much disk space?

I was also under the impression that these temp files would not be persistent since they are created by a temporary form but they last even after the form is destroyed..am I missing something here?

I know its really two questions but thanks for any help.