Re: MOS: Mystifying the user community (SR #3-1090025121: Report Issue with this site)
Date: Thu, 10 Dec 2009 12:05:01 -0800
Message-ID: <bf46380912101205q17f3dc03yf890b6ff6ed77085_at_mail.gmail.com>
On Thu, Dec 10, 2009 at 6:46 AM, Bill Ferguson <wbfergus_at_gmail.com> wrote:
> but the current design is
> that technical SR's and non-technical SR's are in different tables
> (presumably for perfomance issues), hence the current requirement to
> specify through that funky pencil filter, what kind of SR's you want
> to view.
>
>
Gee, partitioning wasn't in the budget?
All sarcasm aside, it would be my guess (yes, 'guess' as there are no facts forthcoming to base this on) that the developers and database designers did want to use partitions, but were working under constraints (time probably) that disallowed updating the legacy design to the extent required to merge the data.
If so, not a good decision IMO.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 10 2009 - 14:05:01 CST