We experienced a slowdown of an application and found that by putting in a DELETED() index the performance gained. However, in doing so other area's where a select was being done on this table the performance really slowed down.

An attempt was to set deleted off before the query and then reset afterwards did make some improvement.

Alternate attemp was to put NOFILTER in the query and it made a vast difference.

Hence we are finding that we do need a DELETED Index and by putting NOFILTER in the query has gained us the most bennefits.

Question I have is what is the draw back of putting a NOFILTER in all of our query's? Realizing that in should not be necessary, but it the quickest way to make performance issues.

Any comments would be greatly appreciated