 |
 |
Archives of the TeradataForum
Message Posted: Fri, 12 Dec 2003 @ 20:18:32 GMT
| Subj: | | Re: Concurrent Loads/Deletes for Staging Table |
| |
| From: | | Duane Angle |
| | OK. So, you are happy with the staging table and your concern is only about the master table, right? | |
Yes, that's right.
| | From your original posting I understood that you store only one month at a time in the master table. If there are multiple
months my suggestion to restructure the PI should include the month column as well. | |
Yes - we only store the one month in the Master table. That being the case, I suppose we could just delete by company_cd, so I see where
you are going there.
| | It would be good to understand what causes the table lock. May I ask how you do your deletes exactly? You do not use MLOAD,
right? Do you have SIs on the master table? | |
The deletes are performed with BTEQ scripts (no MLOAD). We do not have any secondary indexes on the Master table at this time.
| | That would be my bet. We should be able to do concurrent transactions,shouldn't we? The PI way should be the easiest for
TD. | |
I can look at that option and see if its helps at all.
Thanks a lot for taking the time to respond!
| |
