>I have a TIMESTAMP field and using a SQL like
>
> SELECT .....
> WHERE CAST(T2.CHECKIN_TIMESTAMP AS DATE) = 'NOW'
>
> If i add an index of CHECKIN_TIMESTAMP will it speed up the search?

No. (unless you have Firebird 2 and create expression index.)

Ivan
http://www.volny.cz/iprenosil/interbase/