Scheduling people. Work schedules mostly.

Joe works on monday, tuesday, wednesday at location X , Thursdays and fridays on location Y. The schedules have a beginning date and an end date...

Matthew Bailie (9/26/2007)

---

The way I would do it is with partitioning and a view. Though I think you discounted this when you mentioned "materialised views", I was wondering why...

Jeff Moden (9/25/2007)

Triggers make their own transaction, so-to-speak... that transaction, and therefore, the insert, will end when all of the triggers on Table A are done firing. If those...

Jeff Moden (9/25/2007)

---

I'm thinking that Remi thought you were going to move the triggers that did the insert/update on table B to table B... and that's not what you intend...

Of...

Here is the reason why I have that trigger.

In Table A there are a couple of million records. A legacy application needs them there.

There are apps which need to frequently...