> > I can also attest to the horrendously long time it takes to restore the ADD > > FOREIGN KEY section... > > 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.
Surely in the default case it would reduce to using the new hashed IN() feature, so it'd be a lot faster? Chris ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])