SELECT 
 RECIPIENT_ID ,FAX_STATUS 
 FROM 
 FAX_STAGE WHERE LOWER(FAX_STATUS) like 'moved to%'

 Execution Plan
----------------------------------------------------------

----------------------------------------------------------------------------------------
| Id  | Operation                   | Name                | Rows  | Bytes | Cost (%CPU)|
----------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |                     |   159K|    10M|  2170   (1)|
|   1 |  TABLE ACCESS BY INDEX ROWID| FAX_STAGE           |   159K|    10M|  2170   (1)|
|   2 |   INDEX RANGE SCAN          | INDX_FAX_STATUS_RAM | 28786 |       |   123   (0)|
----------------------------------------------------------------------------------------

Note
-----
   - 'PLAN_TABLE' is old version


Statistics
----------------------------------------------------------
          1  recursive calls
          0  db block gets
         21  consistent gets
          0  physical reads
          0  redo size
        937  bytes sent via SQL*Net to client
        375  bytes received via SQL*Net from client
          3  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
         19  rows processed

SELECT COUNT(*) FROM FAX_STAGE--3679418

SELECT DISTINCT FAX_STATUS FROM FAX_STAGE;
Completed
BROKEN
Broken - New
moved to - America
MOVED to - Australia
Moved to Canada and australia

Functional based index on FAX_STAGE(LOWER(FAX_STATUS))

$ORACLE_HOME/rdbms/admin/utlxplan

'ORACLE_HOME' is not recognized as an internal or external command,
operable program or batch file.

EXEC dbms_stats.gather_table_stats('ORL','FAX_STAGE',ESTIMATE_PERCENT=>100,METHOD_OPT=>'for all indexed columns size auto',CASCADE=>True);
ANALYZE TABLE ORL.FAX_STAGE ESTIMATE STATISTICS SAMPLE 100 PERCENT for table for all indexed columns;

SELECT DISTINCT LOWER(fax_status) FROM ORL.FAX_STAGE;

LOWER(FAX_STATUS)
broken          
broken - new   
completed   
new 
move to - america
move to - canada

select index_name, clustering_factor
from all_indexes where index_name = 'INDX_FAX_STATUS_RAM';

INDX_FAX_STATUS_RAM  165139

SELECT FAX_STATUS,count(*)
FROM fax_STAGE
GROUP BY FAX_STATUS;

FAX_STATUS    COUNT(*)

BROKEN          10
Broken - New    9
Completed    2324493
New             20
move to - america 250
move to - canada  250

ANALYZE TABLE ORL.FAX_STAGE ESTIMATE STATISTICS SAMPLE 100 PERCENT for table for all indexed columns;