Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Seek predicate Vs Predicate Expand / Collapse
Author
Message
Posted Tuesday, October 16, 2012 2:06 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 2:29 PM
Points: 299, Visits: 1,134
Can someone please explain the difference between Seek predicate and predicate in execution plans?
Post #1373515
Posted Tuesday, October 16, 2012 11:09 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, December 6, 2014 1:32 AM
Points: 81, Visits: 944
refer below link

http://blog.sqlauthority.com/2009/11/09/sql-server-removing-key-lookup-seek-predicate-predicate-an-interesting-observation-related-to-datatypes/
Post #1373624
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse