CODEWITHSUNDEEP
sql-serverquery-performancesqlperformancesqldatetime
richard
richard

Reputation: 12534

Is date type more performant than datetime for queries on large datasets?

I'm storing calendar event dates, including recurring events. The table could get huge. Most of my queries are for ranges of a month (i.e. where eventstart >= '1/1/2001' and eventstop <= '1/31/2001') so I don't care about time so much in my queries.

Would I get better performance in range queries if I queried a date column vs a datetime column?

Upvotes: 1

Views: 378

Answers (1)

Vincent
Vincent

Reputation: 882

Rule 1) Always use the smallest data size that will accommodate the largest possible value.

http://www.sql-server-performance.com/2007/datatypes/

Upvotes: 1

Related Questions