On Aug 22, 2011, at 2:17 PM, Grigori Solonovitch wrote:

> Thank you very much, Richard. This query is much faster and gives the same 
> result from data point of view.
> I have only question about period of time from 00:00:00 till 00:02:59.
> Is this query correct for mentioned period of time?
> 
> Grigori G. Solonovitch

I had a hunch you would ask about that.  The technique is an expedient to 
compensate for unfortunate overhead in a generalized query (despite DATE_TIME 
being an indexed field).  It works where the Select is invoked on the same day 
as the pertinent records being queried.  Consider midnight to be a boundary 
exception.  In any case, you should be asleep in bed at that time.  :-)

    Richard Sims