SQL that causes a Full Table Scan (FTS)

  • Nonequality comparisons
  • Column_name IS NOT NULL
  • All NOT Conditions
  • SUBSTR(column_name)
  • Column_name BETWEEN .. AND ..
  • Condition 1 OR Condition 2
  • All Aggregates – SUM, MAX, MIN, AVG, COUNT
  • DISTINCT
  • ANY
  • ALL
  • INDEX (column_name)
  • Column_1 || Column_2 = value
  • Column_name LIKE
  • Missing WHERE Clause

 

If You need more click here www.iguddy.com