Databases :: Oracle :: union oracle slow |
|||
By: Nono  |
Date: 07/10/2005 10:56:14  |
Points: 20 | Status: Answered Quality : Excellent |
| I find the Oracle UNION quite slow. Any idea why ? | |||
| By: VGR | Date: 07/10/2005 10:58:59 | |
Type : Answer |
| Probably a missing index... Try to EXPLAIN PLAN. See also this PAQ for discussion of the merits of UNION versus UNION ALL You can also speed up the overall query by splitting it into the individually unioned ones and managing the dataset yourself in your front-end program or script. This is an especially spectacular improvement in performance, unless you wanted to do a UNION and not a UNION ALL. Hope this helps |
|||
|
Do register to be able to answer |
|||
©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!
Contact
- Privacy
- Contact us
- Member Agreement
- Jobs for our Experts
- our friend ActuLab
- Carcasherdotcom Seocontest
- Add Your Link
- Bee Web Directory
- Discover Directory
- FFind Directory
- Link Velocity Directory
- The Little Web Directory
- Red Links
- Tranix
- 2space Global Directory
Fully downloaded more than 1313 Million times
Copyright © 2003 - 2012 The IT European Experts Organization
last update on : 23/07/2008 09:41:27 GMT 0 (CEST)
