I'm currently setting up a table to contain user login/logout
information. Just wondered what would be more scalable??better to
index,etc...
Having a 'timestamp' field 'CCYY-MM-DD HH:MM:SS.SS' or two separate
fields one for time 'HH:MM:SS.SS' and one for Date 'CCYY-MM-DD'.
most queries will be of the form:
------------------------------------------------
select ........ from <table> where username='xxx' and date<'CCYY-MM-DD'
and date>'CCYY-MM-DD'
------------------------------------------------
so I was thinking that a separate 'Date only' field would index better..
Any Thoughts??
--
Dale Walker dale(at)icr(dot)com(dot)au