(no subject)
May. 24th, 2007 03:26 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
semperfionaToday'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
![[identity profile]](https://www.dreamwidth.org/img/silk/identity/openid.png){kind=small}
no subject
Date: 2007-05-24 08:27 pm (UTC)