Originally posted by vijay jamadade:
As per your explanation regarding that this reindexing gets applied to the existing data and I need to repeat it after the table will get more data added.
As Martijn wrote, you need to do it periodically, as needed. How often is hard to predict. Clearly as you add more records. And if you change the field values in the rows often, you need to do it more often.
The trick is to figure out how often to do it without having the indexing get in the way of production. Its a non-trivial balancing act.