Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does create sql view create bloat?
Message
 
 
To
16/07/1999 10:49:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00242308
Message ID:
00242680
Views:
21
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform