Seek predicate Vs Predicate

• sunny.tjk

  SSCertifiable

  Points: 5041

  More actions

  October 16, 2012 at 2:06 pm

  #263420

  Can someone please explain the difference between Seek predicate and predicate in execution plans?

• mahesh.dasoni

  SSCommitted

  Points: 1653

  More actions

  October 16, 2012 at 11:09 pm

  #1549864

  refer below link

  http://blog.sqlauthority.com/2009/11/09/sql-server-removing-key-lookup-seek-predicate-predicate-an-interesting-observation-related-to-datatypes/