RE: Re[2]: Re[2]:Upgrading Oracle

From: Diana Duncan <Diana_at_fileFRENZY.com>
Date: Wed, 25 Oct 2000 13:01:38 -0400
Message-Id: <10660.120186@fatcity.com>

Rachel wrote
"...a third party product that
denormalizes tables because their "experts" told them that if you have more than 4 tables in a join performance suffers significantly."

This is something I get from our chief architect on a regular basis, and he won't believe me when I say it all depends on the size of the tables, the indexes on the tables and the query criteria. He is dead set that the number of tables in a join determines the performance of the query. Does anyone know where I can find a concrete explanation that I can have him read to disabuse him of this notion?

Thanks, Received on Wed Oct 25 2000 - 12:01:38 CDT