Hi Chris,

The indexes on a table and on a view are two separate issues. You would usually add indexes to a table to make query against it optimizable. The indexes on a view usually are used to display it in a grid in different order.


>At first it seems I was creating the index on both the source table and the view. I was trying to create an index that I could use to sort my records into "entry order" rather than using the PK value. I didn't realize I had created an index for both the base table, and the view. I don't know what standard protocol is, but creating one for both seems redundant, and probably isn't a good idea.
>
>The index expression is simply "datetime"