Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Does create sql view create bloat?
Message
 
 
À
16/07/1999 10:49:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00242308
Message ID:
00242680
Vues:
25
Todd,

You could use a temp dbc to hold your views.

>I have a program that needs a special view of the remote database. To allow for changes in the remote database structure, I would like to re-create the view every time I run the program. (Maybe not the best way, but its expedient.)
>
>Will running CREATE SQL VIEW myview multiple times create a bloat? I remember that INDEX ON ... TAG MYTAG run a bunch of times without deleting the tag first would end up making the CDX file grow. Does the same problem exist with .dbc files?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform