infogulch

Predicates from the top down

May 23rd, 2012
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. Fist predicate:
  2.  
  3. [1] Seek Keys[1]: Prefix: [db].[dbo].[SOP10100].SOPTYPE = Scalar Operator((2)), [2] Seek Keys[1]: Prefix: .[dbo].[SOP10100].SOPTYPE = Scalar Operator((5))
  4.  
  5. Second predicate:
  6.  
  7. substring([db].[dbo].[SOP10100].[CUSTNMBR] as [Header].[CUSTNMBR],(1),(1))='3'
  8.  
  9. Third predicate:
  10.  
  11. [db].[dbo].[SOP10100].[SOPTYPE] as [Header].[SOPTYPE]=(2) OR [db].[dbo].[SOP10100].[SOPTYPE] as [Header].[SOPTYPE]=(5)
Advertisement
Add Comment
Please, Sign In to add comment