|< < 32 > >|

Optimizing multi-table queries

Extending a plan

Example

Schema


Tables:

    R(rid, a)
    S(sid, rid references R, b)

Indexes:

    R(rid) -- PK
    S(sid) -- PK
    S(rid) -- FKs usually have indexes
    S(b)

|< < 32 > >|