The subject of table accessfull in explain plan encompasses a wide range of important elements. Oracle SQL EXPLAINPLAN - fulltableaccess - Stack Overflow. Full table scanning isn't necessarily a bad thing, though it can be a good place to start if a query is unacceptably long running and the suspicion is due to an FTS on a very large table. How to avoid the full table scan - Ask TOM. As we can see, CBO has produced the execution plan, without using full table scan.
What you were demonstrating was more like an exception (tables filled with constant values), than a rule, for a given table structure and a given query against them. Detecting Full-table Scans (using explain plan) - RelationalDBDesign. This page describes how to identify a full-table scan using the EXPLAIN PLAN utility to access tables and indexes
📝 Summary
Through our discussion, we've investigated the various facets of table access full in explain plan. This knowledge not only inform, while they help individuals to benefit in real ways.