Re: Performace with 500,000 tables

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Fri, 20 Dec 2002 13:44:47 +1100
Message-ID: <jlvM9.6746$jM5.19160@newsfeeds.bigpond.com>

I'd have to question any design for a database that requires half a million tables. Point of fact, I can't imagine any circumstances when that number of tables would be required.

So go on, enlighten me!

But no, the number of tables should not in and of itself make any discernible impact on performance. But the bodgy design that requires that many tables will inevitably cause grief, big time.

Regards
HJR "Massis Isagholian" <massis_at_att.com> wrote in message news:totM9.4801$p_6.376353_at_bgtnsc04-news.ops.worldnet.att.net...
> Does a large number of tables (say 500,000) in an Oracle database affect
> performance? If so, what exaclty is affected?
>
> Thanks,
> Massis
>
>
>
Received on Thu Dec 19 2002 - 20:44:47 CST