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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s