QUESTION:

Lately we have noticed lot of performance issues propping  up with report designer reports when ever a date column is used  as Filter condition , we do see that a function F_DropTime gets attached to the  filter condition due to this function even the Indexed  data  is taking a lot of time to execute.
Is there way to avoid this function for certain reports?


ANSWER:

It seems that function is tided to condition "Between" used to filter on the period between two dates. Certain conditions have time portion removed such as has/has no value.
Some conditions do not remove time portion for the date time stamp such as less then or greater then. Try using these conditions if you want to avoid F_DropTime function.