Search notes:

Oracle SQL Plan operation INDEX FULL SCAN

drop table tq84_tab;
create table tq84_tab (
   col_1 varchar2(10),
   col_2 varchar2(10),
   col_3 varchar2(10),
   col_4 varchar2(10)
);

create index tq84_tab_ix on tq84_tab (col_3, col_4);

explain plan for
   select
      col_3,
      col_4
   from
      tq84_tab;

select * from table(dbms_xplan.display(format=>'basic'));
--
-- --------------------------------------
-- | Id  | Operation         | Name     |
-- --------------------------------------
-- |   0 | SELECT STATEMENT  |          |
-- |   1 |  TABLE ACCESS FULL| TQ84_TAB |
-- --------------------------------------


explain plan for
   select
      col_3,
      col_4
   from
      tq84_tab
   where
      col_3 is not null;

select * from table(dbms_xplan.display(format=>'basic'));
-- 
-- ----------------------------------------
-- | Id  | Operation        | Name        |
-- ----------------------------------------
-- |   0 | SELECT STATEMENT |             |
-- |   1 |  INDEX FULL SCAN | TQ84_TAB_IX |
-- ----------------------------------------

alter table tq84_tab modify col_3 not null;

explain plan for
   select
      col_3,
      col_4
   from
      tq84_tab;

select * from table(dbms_xplan.display(format=>'basic'));
--
-- ----------------------------------------
-- | Id  | Operation        | Name        |
-- ----------------------------------------
-- |   0 | SELECT STATEMENT |             |
-- |   1 |  INDEX FULL SCAN | TQ84_TAB_IX |
-- ----------------------------------------

See also

INDEX FULL SCAN (MIN/MAX)
The SQL plan operation INDEX FAST FULL SCAN.
INDEX FULL SCAN (MIN/MAX) feeding into FIRST ROW

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758199315, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL/statement/execution/plan/operations/index_/full-scan/index(102): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78