Re: schema question
From: Dwayne King <dwayne_at_kridan-consulting.com>
Date: Mon, 20 Nov 2000 01:03:10 GMT
Message-ID: <iL_R5.138016$78.42573149_at_news3.rdc1.on.home.com>
Date: Mon, 20 Nov 2000 01:03:10 GMT
Message-ID: <iL_R5.138016$78.42573149_at_news3.rdc1.on.home.com>
Clark,
Hands down, the first is most efficient, and more more in data modelling.
Administration would be an absolute NIGHTMARE, if you had a table for each user, let alone how you are going to handle dynamically createing objects at runtime whenever a new user is created, dropping objects when a user is removed etc. Shared pool and library cache tuning also becomes difficult. Don't go there.
With Oracle, you can also take advantage of partitioning to speed up searches etc, so you will get a boost there as well. It will never be as fast as only searching a table of 10 rows, but in my opinion that is a waste of space anyways unless your extent size is ridicuolously small.
DK Received on Mon Nov 20 2000 - 02:03:10 CET