Advice on indexing a datetime column

[Michaël Ball]

Hi,

I am looking into optimizing a database, and I've highlighted a particular 'datetime' column in a table that could benefit from being indexed. However, I would appreciate some advice about whether or not what I intend to do will degrade performance of the table in other areas.

The table stores GPS positions and is being constantly updated with data from hundreds of GPS devices every second. Would indexing on the 'datetime' column of this table greatly affect the speed at which the table processes the data coming in? I am little unsure, as the datetime value should always be sequential (subsequent data coming in will always have a datetime value greater than previous entries in the table). Can anyone offer any suggestions on this?