enforcing a plan (in brief)

From: "Hicham G(dot) Elmongui" <elmongui(at)cs(dot)purdue(dot)edu>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: enforcing a plan (in brief)
Date: 2005-02-10 19:07:03
Message-ID: 200502101907.j1AJ73BR007233@newman.cs.purdue.edu
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-02-10 19:37:06 Re: enforcing a plan (in brief)
Previous Message Merlin Moncure 2005-02-10 18:26:34 Re: New form of index "persistent reference"