Re: Many Schemas

On Mon, 07 May 2001,
SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK wrote:
> In a case where one company is providing a service for other
> companies (hundreds, possibly thousands). The same service for
> each one. Would it be better to give each company their own
> schema or to have one schema and use a foreign key to separate
> the common lists. Obviously there are many points to consider,
> but I do not know where to start.

I would say that each company would get its own schema, but these schemas own views into your one schema. Then, each company only sees what the view allows them to see.

Then, hire a really good DBA to tune your main schema and the template of views for accessing it.

-- 
Galen
I don't want to be the rock.  Yeah, okay, what do you want to be?
I want to be the piece of glass.