The reason is that simply any of those statements disallow index usage. An index is built to tell Oracle what exists in a table, but it can not tell it what does not exist. Therefore, queries on a table with negative logic can typically force full table scans.