Re: Performace with 500,000 tables

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Fri, 20 Dec 2002 09:27:58 -0800
Message-ID: <3E03531E.E90C1E58@exesolutions.com>

Massis Isagholian wrote:

> Does a large number of tables (say 500,000) in an Oracle database affect
> performance? If so, what exaclty is affected?
>
> Thanks,
> Massis

If there is an impact it would more likely be a result of any design that resulted in that many tables in the first place.

I find it incomprehensible that any normalized database could possibly contain that number of entities. Even 1/10th that number of entities would make me seriously question the design.

Daniel Morgan Received on Fri Dec 20 2002 - 11:27:58 CST