In SQL, do all the common considerations about indexes apply if everything I'll ever want to query (in the where condition) is when a field is not null?
Is there a special configuration of the index I can apply to cover this specific case?
select id from Accesses where token is not null;
Is it worth to add the index on
token as much as it would be if I had to search for specific token values?
My database is Postgres.