I ran query this morning, I got a wrong results. I have run the same query in an other environment with same data and I got the result set I was expecting.
After that I did a re index and on the table I was getting incorrect results, the data then came out fine,
Do I have to reindex periodically to make sure the data retrieval would be correct?
Thanks for you help
Regards
