Archives of the TeradataForum
Message Posted: Fri, 01 Jun 2001 @ 17:37:26 GMT
| Subj: || || Re: Transaction Debits and Credits |
| From: || || Frank Martinez |
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.
Frank C. Martinez IV