SET AUTOTRACE ON
SELECT   DISTINCT p.chi_Id,
                  p.Status,
                  TRIM(s.sch_Name),
                  t.TownName2,
                  p.hs_College,
                  p.Junior_Senior,
                  p.chi_Name,
                  p.chi_Addr1,
                  p.chi_Addr2,
                  p.chi_Addr3,
                  e.Worked,
                  e.Precinct,
                  e.Position,
                  e.Technical_Judge,
                  p.Date_Train,
                  p.Date_tech_Train,
                  p.Date_e1_Train,
                  p.Date_e2_Train,
                  p.Date_e3_Train,
                  p.eMail_Addr,
                  p.HomepHone,
                  p.WorkpHone,
                  p.CellpHone,
                  p.chi_bDate,
                  s.sch_Precinct,
                  p.Live_pre,
                  (SELECT COUNT(* )
                   FROM   ej_el_Asg e2
                   WHERE  e2.chi_Id = e.chi_Id
                          AND e2.Worked = '1'),
                  (SELECT MAX(cl.Class_Date)
                   FROM   ej_cl_Asg cl
                   WHERE  cl.chi_Id = e.chi_Id
                          AND cl.Election = e.Election)
FROM     Cook.ej_el_Asg e,
         Cook.pwMast p,
         Cook.sch_Mast s,
         Cook.Township t
WHERE    p.chi_Id IS NOT  NULL 
         AND p.chi_Id LIKE 'ST%'
         AND p.chi_Id = e.chi_Id (+) 
         AND e.Election (+)  = '110408'
         AND p.sch_num = s.sch_num (+) 
         AND Substr(s.sch_Precinct,1,2) = t.Township (+) 
ORDER BY 3

Execution Plan                                                                                
----------------------------------------------------------                                    
   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=224 Card=1 Bytes=126)                                                                                                                                                                             
   1    0   SORT (UNIQUE) (Cost=223 Card=1 Bytes=126)                                         
   2    1     NESTED LOOPS (OUTER) (Cost=221 Card=1 Bytes=126)                                
   3    2       NESTED LOOPS (OUTER) (Cost=5 Card=1 Bytes=109)                                
   4    3         NESTED LOOPS (OUTER) (Cost=4 Card=1 Bytes=99)                               
   5    4           TABLE ACCESS (BY INDEX ROWID) OF 'PWMAST' (Cost=3 Card=1 Bytes=65)        
   6    5             INDEX (RANGE SCAN) OF 'PWCHI' (NON-UNIQUE) (Cost=2 Card=1)              
   7    4           TABLE ACCESS (BY INDEX ROWID) OF 'SCH_MAST' (Cost=1 Card=150 Bytes=5100)  
   8    7             INDEX (UNIQUE SCAN) OF 'SCH_MAST1' (UNIQUE)                             
   9    3         TABLE ACCESS (FULL) OF 'TOWNSHIP' (Cost=1 Card=30 By tes=300)               
  10    2       TABLE ACCESS (BY INDEX ROWID) OF 'EJ_EL_ASG' (Cost=216 Card=9842 Bytes=167314)
  11   10         INDEX (RANGE SCAN) OF 'EJ_TECH1' (NON-UNIQUE) (Cost=30 Card=9842)           


Statistics                                                
----------------------------------------------------------
        197  recursive calls                              
      25995  db block gets                                
   77980060  consistent gets                              
        150  physical reads                               
       4180  redo size                                    
     648026  bytes sent via SQL*Net to client             
      22958  bytes received via SQL*Net from client       
        205  SQL*Net roundtrips to/from client            
          6  sorts (memory)                               
          1  sorts (disk)                                 
       3048  rows processed             

p.chi_Id = e.chi_Id (+) 
         AND e.Election (+)  = '110408'