On a custom record with a large number of rows, I'm trying to select the first 1k rows by id. This takes a long time. Are any of the system generated date fields indexed?

why does it take a long time?

What does your query look like ? 1k rec especially on a custom record should be pretty quick. If it's a straightforward select query with no complex joins or where clauses.

It shouldn't take a long time, that's why I'm asking if anyone knows if system date fields are indexed. A date column on a table with millions of rows would be able to do this query in a few milliseconds, which this fails at.