Index on sort column

Question

I have Int type Sort column where I enter numbers to set records sort order. Do I need to index such columns for better performance?

Just in case you'd like to learn more about indexing: SQL Indexing Tutorial — Markus Winand
– Markus Winand, Commented Aug 22, 2011 at 8:54

Alex_L · Accepted Answer · 2011-08-22 08:30:26Z

8

If you want to use this column in your SELECT statement, especially in WHERE, ORDER BY, GROUP BY, TOP and DISTINCT clause - you need to index this field. Please read this article http://www.sql-server-performance.com/2007/optimizing-indexes-general/ to read more about indexes and perfromance.

answered Aug 22, 2011 at 8:30

Alex_L

2,6641 gold badge15 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tobijdc Over a year ago

Link out of date

Collectives™ on Stack Overflow

Index on sort column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related