Re: Query execution for intervals

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.

>