Re: MOS: Mystifying the user community (SR #3-1090025121: Report Issue with this site)
- From: Jared Still <jkstill@xxxxxxxxx>
- To: wbfergus@xxxxxxxxx
- Date: Thu, 10 Dec 2009 12:05:01 -0800
On Thu, Dec 10, 2009 at 6:46 AM, Bill Ferguson <wbfergus@xxxxxxxxx> 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
Other related posts:
