Fastest and most efficient SQL query to check if UID exists

Fastest and most efficient SQL query to check if UID exists