Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.misc -> Re: 3 table query question

Re: 3 table query question

From: <e_humblot_at_wanadoo.fr>
Date: Tue, 23 Jun 1998 23:06:01 +0200
Message-ID: <6mp606$e1m$1@platane.wanadoo.fr>

Try putting the smallest table in the last position of the FROM clause :the optimizer should choose that table for the full table scan. Received on Tue Jun 23 1998 - 16:06:01 CDT

This message: [ Message body ]
Next message: e_humblot_at_wanadoo.fr: "Re: 3 table query question"
Previous message: E: "Oracle Certification: Is it worth it?"
In reply to: spam_at_spam.sucks.com: "3 table query question"
Next in thread: e_humblot_at_wanadoo.fr: "Re: 3 table query question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US