Re: separate data/inidex

> > improvement in query times and in general overall performance. I can
> > only go with what works, in this situation it made a definate
> > improvement.
>
> Absolutely. That is the most important thing to take away from this
> thread: test, verify and if you find that something works well and
> consistently so, then use it. And keep re-testing: next version of your
> software or next version of Oracle things might not be the same. By all
> means get and share ideas with others. Either through seminars,
> newsgroups or mail lists. But use of the grey stuff between the ears is
> not excluded.

In theory this sounds good. And I'm not dismissing it.

But the reality is that no-one in the real-world has the time to try installing Veritas and striping one way, installing the application, benchmarking it. Then striping another way, etc. No has the luxury of making comparisons of RAID 0+1 with RAID 5. Maybe if you work for Oracle or in a test lab. But not anyone being paid for application development or production DBA work. If I went to management and told them I needed an extra 90 days to role out an application while testing these basics I would find myself standing in an unemployment line and I've no doubt such would be the fate of everyone else here other than perhaps Tom.

Therefore, it falls to those that can, to come up with rules of thumb based on testing and to make information on what they discovered available to the larger community.

Else ... using old and likely invalid myths is all there is.

Daniel Morgan Received on Sat May 04 2002 - 14:26:18 CDT