No surprise. You do not have a definite SARGABLE query as well as no indexes to be supported. Hence the query has to scan the entire table.
You may try creating a clustered index on Col3 and see the improvement. BTB, whats your density of NULL values in Col3 ?
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