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.