Hello, I have a column in a table that gets updated very often(may be every second or more) and this column is used in many where clause in my queries. Should I index this column? Also, my database will eventually gets to more than 1 million records. Thank you.
It's not 100% certain without understanding your structure and usage, but most likely you would be better off with it indexed.
Well sure it may help if you are making your selects based on that column but you should also consider the fact that indexing degrades your DB performance if you are inserting tons of data in that table.
Indexing makes select quieries faster – so you will definetly need it cuz you have so many records… But it makes it slower (not that much though) for updated operations.. I guess you need an index in your case
I once worked on a table that had over a million records that got hammered at certain times of the day. I messed around with indices on some of the columns, inserts became so slow that I ended up using the 'ignore' keyword so selects would continue working. It's hard to say what you would require without seeing the schema and what you need it to do.