Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: fatzlewinski
- Order by date
-
TD Trigger takes much longer than executing the individual statements
An incident will be opened. We found a possible bug not with the trigger but with the TD Optimizer. We ran lots of scripts and checked the explains. When the target table was empty the execution plan was different to when the target was populated. (No statistics). The change in plans always...- fatzlewinski
- Post #3
- Forum: NCR: Teradata
-
TD Trigger takes much longer than executing the individual statements
We are puzzled as to why a trigger set FOR EACH STATEMENT takes longer than executing the individual SQLs by hand. Our trigger reacts after a table receives inserts. The trigger is set FOR EACH STATEMENT. An insert select statement is fired from an applicaion but the statement seems to block up...- fatzlewinski
- Thread
- Replies: 2
- Forum: NCR: Teradata
-
Stopping Teradata Demo on XP
I have installed the TD Demo on Win XP Pro. I can start it, access it and use WinDDI, QMan, CRM etc. I have two problems. First I can't start the demo when the Notebook is connected to a network. This is minor, annoying but easily remedied by removing the cable, starting and re inserting the...- fatzlewinski
- Thread
- Replies: 1
- Forum: NCR: Teradata
