Archives of the TeradataForum

Message Posted: Thu, 17 Aug 2006 @ 10:58:16 GMT

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

<-- Anonymously Posted: Wednesday, August 16, 2006 22:18 -->

Hi David,

Tactical queries are always given more importance than decision support. If this is your case then better to have small block size to reduce the impact of non-table scan. Else you can think of mid-size blocks which will be better for both the purpose.

I think it all depends on the type and number of queries which uses that table.

Regards.

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