How to kill an index - III

• Data type conversion prevents use of indexes, e.g:

  • SELECT name, address, tel
  • FROM adresslist
  • WHERE tel = 51213344
  • -- VARCHAR2 to INTEGER conversion
  • -- (tel is VARCAHAR2 (16) )

Notes: