Archives of the TeradataForum

Message Posted: Fri, 01 Jun 2001 @ 17:37:26 GMT

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

Having seen "negative" credits and positive "debits" at various banks, I would think a separate field would be most appropriate. However, actually, it's a never-mind, since what really affects things in Teradata is skewed tables, which I've seen result from a transaction table that mixes transactions from accounts for individuals with transactions from (for example) government agencies. If the index is not the transaction id (which sometimes isn't a very good index because it's not used in joining), the index has to have enough uniqueness for the large chain of transactions on accounts with different statistics than individual accounts. For example, say that the best index for access was account and accounting month. This would probably work for the transactions for most accounts (less than 100/month), but not for some account that has thousands per month. So some other column has to be in the index. But then, for most of the transactions, the index isn't particularly useful. This is a case where it might be necessary to separate these two type of transactions into separate tables, based on the statistics (not COLLECT STATISTICS) of the transactions. Anyway, I know I wandered off into strange territory, but hopefully that may be useful.

iv

Frank C. Martinez IV

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