sample 1:




[sql] ​​view plain​​​ ​​copy​​


  2. select /*+INDEX(t IDX_SEL_ADD_DATE)*/ t.own_sys, count(1)
  3. from std_entp_login t
  4. where t.add_date >
  5. to_date('2010-12-28 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
  6. and t.add_date <
  7. to_date('2010-12-28 23:59:59', 'yyyy-mm-dd hh24:mi:ss')
  8. group by t.own_sys



用到别名时，/*+INDEX(TABLE INDEX_NAME)*/中的TABLE一定是别名，否则不走执行强制索引。