Queries reporting a scan count of 1

Examples of queries that return a scan count of 1 are:

If the columns in the where clauses of these queries are indexed, the queries can use the indexes to scan the tables; otherwise, they perform table scans. In either case, they require only a single scan of the table to return the required rows.