I found that the following index greatly speeds up RT on systems with lots of ObjectCustomFieldValues. CREATE INDEX ObjectCustomFieldValues3 ON ObjectCustomFieldValues (ObjectId,ObjectType); -Todd