IN subquery

• F = cardinality of subquery result /
  product cardinality of relation in subquery from all the relation in FROM list;
• Sig : Uniqe index = 1+1+ w

• Sig : Clustered Index matching boolean factors =
  Predicates*(N INDEX(I)+TCARD) + W* RSI-CARD
  W = CPU cost weightage factor
• Nested Loop Join : C.outer(path1) +N * C.inner(path2)
• RSI-CARD = No of RSI Calls.
• Sig : Uniqe index = 1+1+ w