On Fri, 15 Aug 2003, Andreas Pflug wrote: > Stephan Szabo wrote: > > >That really needs to be rewritten to do a single check over the table > >rather than running the constraint for every row. I keep meaning to get > >around to it and never actually do. :( I'm not sure that in practice > >you'll get a better plan at restore time depending on what the default > >statistics give you. > > > This is clearly a case for a statement level trigger, as soon as > affected rows can be identified.
Well, I think single inserts might be more expensive (because the query is more involved for the table joining case) using a statement level trigger, so we'd probably want to profile the cases. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
