First of all you have NO indexes on your table. As am not aware of your table structure and the query types, am afraid on suggesting a clustered index. However, you need to create an index on CreateDate to support your query. For a testing purpose, you may create a clustered index on createdate and examine your query execution and its plan.
Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
No comments:
Post a Comment