Archives of the TeradataForum

Message Posted: Thu, 24 Nov 2011 @ 10:38:47 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

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

Rishi Agarwal

	<Prev	Next>		<<First	<Prev	Next>	Last>>