Advertisement
Guest User

Untitled

a guest
Dec 5th, 2016
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. IdInfoComp : Integer Not Null (PK)
  2. IdDefinition : Integer Not Null (FK)
  3. IdObject : Integer Not Null (FK)
  4. Value : NVarChar(Max) Not Null
  5.  
  6. SELECT AVG(Value) FROM InfoComp
  7. Result : 8
  8.  
  9. (Size(IdInfoComp) + Size(IdDefinition) + Size(IdObject) + AVG Size(Value)) * Rows count
  10. ( 4 + 4 + 4 + ((8 * 2) + 2)) * NbRows
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement