Re: many Union all vs. inserting results to temp table

From: Joel Garry <joel-garry_at_home.com>
Date: 21 Mar 2006 15:19:06 -0800
Message-ID: <1142983146.551844.53240@e56g2000cwe.googlegroups.com>

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14237/limits003.htm#sthref4186 scroll down to the first note.

Other than that, try it on a busy system and report back the results. I suspect you will have undo issues with thousands of unions by multiple users if the source table is being updated.

Who did your design?

--
@home.com is bogus.
http://www.lateralscience.co.uk/ymboa/galvreanim.html

Received on Tue Mar 21 2006 - 17:19:06 CST

This message: [ Message body ]
Next message: Mark C. Stock: "Re: many Union all vs. inserting results to temp table"
Previous message: deann15_at_yahoo.com: "many Union all vs. inserting results to temp table"
In reply to: deann15_at_yahoo.com: "many Union all vs. inserting results to temp table"
Next in thread: Joel Garry: "Re: many Union all vs. inserting results to temp table"
Reply: Joel Garry: "Re: many Union all vs. inserting results to temp table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US