On 5/31/07, Jonah H. Harris <[EMAIL PROTECTED]> wrote:
Or, you just use the features you pay for and use COMMIT NOWAIT.
Doh! Got mixed up on the conversation, that wouldn't help. But you could use Oracle's in-memory UNDO, which would not be as costly as a normal update. -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 3rd Floor | [EMAIL PROTECTED] Iselin, New Jersey 08830 | http://www.enterprisedb.com/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
