>Can indexes get corrupted even records are never appended to or deleted from a table.
>Also
>Do select statements make use of indexes at all?
>
>
>Dave.
An index can get corrupted if you are making modifications to the data also and the PC get turned off or the power goes off in the middle of an update.
Yes select statements make use of the indexes that are present and can help speed things up.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope