Automatically select optimal iterator type for embedded/remote space
Description
Currently the CURSOR iterator type is recommended for remote spaces, whereas PREFETCH_UIDS is preferred for embedded spaces. This improvement automatically selects the preferred iterator type if the user has not specified one.