enforcing a plan (in brief)

Is there a way to bypass the optimizer and to specify a plan to be executed?

Something like:



Limit  -> Nested Loop     -> Nested Loop         -> Seq Scan on tab00 t00        -> Index Scan using tab03_pkey on
tab03t03                 Index Cond: ("outer".id = t03.id)    -> Index Scan using tab01_pkey on tab01 t01
IndexCond: ("outer".id = t01.id)