Real-Time Timestamps?

If I understand Oracle correctly, the Date/Time type only supports time down to the seconds. So my question is how do people handle finer-grain times (say down to hundredths of seconds). For instance, in a manufacturing environment, many things could happen within the space of a second, but the history of what happens may be kept for years. Do people put timestamps on database records using two columns (one for a standard Date/Time type and one for parts of a second)? Doesn't this make the data harder to refer to (or index)?

--


====================================================================

David Masterson					Consilium, Inc.
(415) 691-6311					640 Clyde Ct.
davidm_at_consilium.com				Mtn. View, CA  94043


====================================================================

"To be good, according to the vulgar standard of goodness, is obviously 
 quite easy.  It merely requires a certain amount of sordid terror, 
 a certain lack of imaginative thought, and a certain low passion for 
 middle-class respectability."
-- Oscar Wilde