Posted by bie2 on 05/19/06 18:45

Tried this simple query

SELECT D.ID
FROM Datas as D
WHERE D.Date BETWEEN '5/18/2006' AND '5/18/2006'

And still took me 3 minutes, So maybe the problem is with the index on
DATAS

• Next in forum: Re: Numbering in SQL
• Prev in forum: Re: Parsing a varchar(79) column
• Thread view: Re: Help to optimize query

[Reply to this message]