Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: 3 table query question
Try putting the smallest table in the last position of the FROM clause : the
optimizer will access this table first hence issuing a full table scan on it
(instead of a larger table)
Received on Tue Jun 23 1998 - 16:06:35 CDT