| Subject | index on TIMESTAMP field to facilitate search on DATE |
|---|---|
| Author | d_dude_2003 |
| Post date | 2006-01-24T17:41:12Z |
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?
Thanks.
SELECT .....
WHERE CAST(T2.CHECKIN_TIMESTAMP AS DATE) = 'NOW'
If i add an index of CHECKIN_TIMESTAMP will it speed up the search?
Thanks.