Simple Queries
The simplest of the queries is the simple query, or a query against one table. An example is:
SELECT ename,deptno FROM emp;
Minimal effort is required to determine how to process this query. In this case, Oracle performs what is called a full table scan; that is, Oracle reads every row in the table from disk.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
