The USER_INFO_BASIC view contains information about user profiles.
This view returns a subset of columns that are returned by the USER_INFO view. It does not return: USER_OWNER , USER_CREATOR, SIZE, CREATION_TIMESTAMP, LAST_USED_TIMESTAMP, DAYS_USED_COUNT, or LAST_RESET_TIMESTAMP. USER_INFO_BASIC typically performs much better than USER_INFO.
Was this topic helpful?
13 April 2021