Re: Designing database tables for performance?

On Feb 23, 2:06 pm, Frank Hamersley <terabitemigh..._at_bigpond.com> wrote:
> Cimode wrote:
>
> [..]
>
> > Yep. Last time I discussed database issues with an ORACLE guru, he
> > was trying to convince me that RAM was logical as opposed to Hard
> > drive which was physical. To the ORACLE gurus, as soon as it is in
> > memory, it becomes totally logical. A total absurdity of course...
>
> He was prolly talking about the types of IO's for a query that the
> optimiser predicts and execution engine encounters. Sybase uses the
> same terminology and weights them differently when costing out
> (possible) plans.
>
> Cheers Frank.

In what RAM would be less physical than HD ? For any reason, an absurdity is an absurdity. Received on Fri Feb 23 2007 - 14:24:12 CET