[HACKERS] enforcing a plan (in brief)

[Hicham G. Elmongui]

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 tab03 t03  
                Index Cond: ("outer".id = t03.id)
     -> Index Scan using tab01_pkey on tab01 t01  
              Index Cond: ("outer".id = t01.id)




---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster