Oracle partitioning

From: Kary <kalapanda_at_yahoo.com>
Date: 22 Aug 2005 10:53:01 -0700
Message-ID: <1124733181.210515.320680@f14g2000cwb.googlegroups.com>

All,

I am working on a solution where a company is hosting a website (portal) where it has its dozen or so customers log in and run reports(ad-hoc and canned).

Each customer will query his/her own data (no queries across customers). This is indeed the case and just for the sake of discussion let us also assume this situation will not change ( given that change is the only constant!).

Would it make make sense for the hosting company to partition by customer then ? Is it possible and would it help to further partition by time period i.e say by month(inside of each customer partition).

What are your thoughts on partitioning like above both from a performance standpoint and also from a maintenance standpoint.

Thanks,
KK. Received on Mon Aug 22 2005 - 12:53:01 CDT