Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: In an RDBMS, what does "Data" mean?

Re: In an RDBMS, what does "Data" mean?

From: Anthony W. Youngman <wol_at_thewolery.demon.co.uk>
Date: Tue, 15 Jun 2004 01:04:55 +0100
Message-ID: <ia4f9vJn0jzAFwWF@thewolery.demon.co.uk>


In message <c0e3f26e.0406100132.6b88c3e5_at_posting.google.com>, Tony <andrewst_at_onetel.net.uk> writes
>"Anthony W. Youngman" <wol_at_thewolery.demon.co.uk> wrote in message
>news:<0UZ6uTSqd7xAFwl0_at_thewolery.demon.co.uk>...
>> Relational needs an optimiser - Pick gets it for free ... and the stats
>> say that on average it pays off handsomely :-)
>
>Pick doesn't have a "free" optimizer: it just doesn't have one. So
>either there is only one access path, and too bad if it isn't optimal,
>or you the designer/programmer are playing the part of the optimizer
>yourselves (and I don't suppose your time comes free).

So our time isn't free ... but optimisation is inherent in the design. We don't even think about it - it just happens ...

Cheers,
Wol

-- 
Anthony W. Youngman - wol at thewolery dot demon dot co dot uk
HEX wondered how much he should tell the Wizards. He felt it would not be a
good idea to burden them with too much input. Hex always thought of his reports
as Lies-to-People.
The Science of Discworld : (c) Terry Pratchett 1999
Received on Mon Jun 14 2004 - 19:04:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US