I have a table T with an integer column C. It’s very unlikely that number of T rows will exceed 1000. The system is loaded with real-time queries of two types (each with a same frequency):
- Search for a T row with lowest C and increment it by N.
- Search for a T row by primary key and decrement it back by N.
Should I use an index for for T.C?