Archives of the TeradataForum
Message Posted: Thu, 24 Nov 2011 @ 10:38:47 GMT
We have a table that is very big in size ~ 5TB. For maintenance purpose and also to reduce the loading time by parallel loading, we split the tables in 6 parts. We created a view doing UNINON ALL on these 6 tables to access the data. But, after splitting the table, queries are running slow on this view.
Can anyone advise what could be the reason for the same and alternative to handle the situation.
Thanks & Regards
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|