Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Large table monthly switch design problem
schonlinner_at_yahoo.com wrote:
>As mentioned before: I tested it using a view which then contained
>a union all over 24 tables containing the monthly data. But the
>performance was round about 3 times slower.
<SARCASM>
I'd say that really has your server humming. A UNION over 24 tables...
</SARCASM>
Paul...
> Martin
-- plinehan __at__ yahoo __dot__ __com__ XP Pro, SP 2, Oracle, 9.2.0.1.0 (Enterprise Ed.) Interbase 6.0.1.0=6; When asking database related questions, please give other posters some clues, like operating system, version of db being used and DDL. The exact text and/or number of error messages is useful (!= "it didn't work!"). Thanks. Furthermore, As a courtesy to those who spend time analysing and attempting to help, please do not top post.Received on Wed Jun 29 2005 - 16:38:32 CDT