Archives of the TeradataForum
Message Posted: Fri, 26 May 2000 @ 08:56:56 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|