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: Query execution for intervals

Re: Query execution for intervals

From: Tony Rogerson <tonyrogerson_at_sqlserverfaq.com>
Date: Mon, 6 Feb 2006 15:12:31 -0000
Message-ID: <ds7p06$gk1$1$830fa17d@news.demon.co.uk>


So why say this:

        >>  try putting the end_date into the
        >> PRIMARY KEY to get a covering index

Its about time you started checking your answers, perhaps if you spent a lot less time trying to be clever by putting posters down you might not make so many fundemental mistakes.

-- 
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"-CELKO-" <jcelko212_at_earthlink.net> wrote in message 
news:1139233708.664866.93410_at_g47g2000cwa.googlegroups.com...

>>> Can end_date be part of the PRIMARY KEY if it is declared NULL<<
>
> No, but can put it in a unique index to get coverage.
>
Received on Mon Feb 06 2006 - 09:12:31 CST

Original text of this message

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