Archives of the TeradataForum

Message Posted: Fri, 26 May 2000 @ 08:56:56 GMT

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

It's interesting that dropping date from your index should give a significant improvement in query time. I assume that you're talking about a primary index of store, product and date. Wouldn't removing date hurt data distribution and therefore performance?

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