Contents

• Access Path Selection : Indices to use, join orders
• Access Specification Language : Machine code language.
• Relational Storage Syatem: RSS
• Relational Storage Inteface: RSI
• Index and Segment scans.
• Search arguments (sargs). "Saragable" predicate . column operator value.
• Cost page fetches + W * rsi calls ( W : CPU weight )
  rsi calls and estimation no. tuples from RSS.
• Predicate ( set of Predicate ) matching an index access path.