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: Indexes and Logical design

Re: Indexes and Logical design

From: David Cressey <david.cressey_at_earthlink.net>
Date: Sun, 11 Sep 2005 22:47:14 GMT
Message-ID: <St2Ve.10432$9i4.2220@newsread2.news.atl.earthlink.net>

"VC" <boston103_at_hotmail.com> wrote in message news:6fKdnesW9crnw77eRVn-iQ_at_comcast.com...
> > It has to do with the real world. Nothing that needs to concern you,
VC.
>
> Very cute.

Thank you.
> > Not true. In DEC Rdb/VMS a unique constraint can be declared without
> > creating an index, if you want to.
>
> For toy tables probably. In 'real world', no.

In the real world, yes.

>
> > There are actually cases, though rare, where that's the right thing to
do.
>
> For example ?

The exmples I would give aren't terribly germane to the main topic, nor would they prove any important points.

So I'm ducking the question.

> What kind of argument in favour of indexes being part of logical model is
> that ? Are you familiar with the notion of relevancy ?

Yes, the notion of relevancy IS important. But as long as you and I are as divided as we are about the nature of the real world, we are unlikely to come to a consensus about relevancy. Received on Sun Sep 11 2005 - 17:47:14 CDT

Original text of this message

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