Forum Discussion
vanessafvg
Community Champion
Community ChampionGetting rid of source tables after append
If you append a whole lot of tables in 1, is there a way of getting rid of the original tables without losing the data - iit just seems redundant to keep the original tables. When I try to delete...
Hi vanessafvg
What you could do to increase performance is to disable the loading of your source tables in the Query Editor.
This will not only make the data load a bit quicker, but it will also mean that it will not load into your data model. Which means that your data model will be smaller and more efficient.
You can read this blog post by Rezza Rad where he goes into detail.
Does append stores data physically or Logically?
GilbertQ
Super User
Super UserIt stores it physically in the vertipaq compression engine