Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Index taking up too much disk space
Versions des environnements
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement