Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to tune this sucker ??
Evan a écrit :
> Re-order the from clause. Learn to read the plan.
>
> try: from bkcompany comp, bkformat, bkproducttitle pt, bkbookrelease br
>
> Oracle drives the query based on the last table referenced. (MSSQL & DB2
> drive the query based on the first table referenced I believe)
Why don't try to use the statistical optimizer? It is better and it doesn't rely on the order within the FROM clause.
-- MohamadReceived on Wed May 17 2000 - 00:00:00 CDT