General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008
>>IMHO, index on date field (SQL Server 2008) or index on datetime field is all you need. I don't think you need to use any integer conversions, unless you build facts table.
>
>Well, one thing for sure, whenever I remove a date field as part of my where clause, this is much faster. I have found the following sequence:
>
>1. Integer, Boolean and Character fields (Faster)
>2. Add a date field such as StartDate greater than something (Slower)
>3. Add the same date field such as StartDate greater than something AND StartDate less than something (Even slower)
Chances of formulating 3 as "between" without too much recalc for border value exclusion ?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only