p_msantos_at_yahoo.com wrote:
> That's the way it was setup back in 8.1.6 ... long before my time with
> this company. Each customer has a total of 3 tables...so it's not that
> bad to manage. And since data access is based on how / when the
> customer feels like accessing it..there is no access patterns to
> logically separate the data.. of course partitioning a large table
> could be an option.. but that's a whole other topic. I'm trying to
> minimize IO without having to write the entire application.
> -peter
If this is a tuning exercise ... fix it. The easiest way is to had
a column that identifies the customer.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Mar 07 2006 - 16:11:01 CST
