It will be more efficient to narrow the set of keys to evaluate than look at all of them and evaluate the timestamp.
From: Dickson, Matt MR [mailto:[email protected]] Sent: Tuesday, August 20, 2013 7:12 PM To: '[email protected]' Subject: TimestampFilter Performance [SEC=UNOFFICIAL] UNOFFICIAL Is the TimestampFilter an efficient means of filtering results by time ranges? I have the option of extending the existing rowid's, currently pre-fixed with yyyymmdd, to include hhmm also, or make use of the TimestampFilter. In a quick google search someone mentioned that the TimestampFilter was inefficient is this correct? Matt
