Entry tags:
(no subject)
Today's SQL lesson (possibly only applicable to Oracle DB, possibly of
more general application):
One select containing a union = 10 rows, .578 ms
Second select containing a union = 10 rows, .312 ms
==========================================
Union of the above = same 10 rows, 501 SECONDS
more general application):
One select containing a union = 10 rows, .578 ms
Second select containing a union = 10 rows, .312 ms
==========================================
Union of the above = same 10 rows, 501 SECONDS