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

Thanks!
--Todd Sherman
-Wake Up! Smell the Coffee!
Next
Reply
Map
View

Click here to load this message in the networking platform