Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Query Very Slow

Re: SQL Query Very Slow

From: Waco Johnny D <wjdNOwjSPAM_at_myremarq.com.invalid>
Date: 2000/03/08
Message-ID: <1e8f9c6a.ae536ce0@usw-ex0106-045.remarq.com>#1/1

Is the table distribution linear? If not you could try to override the optimizer using the FULL(table_name) hint. I'm just wondering if the indexes are hurting you in the more-complex query.

Received on Wed Mar 08 2000 - 00:00:00 CST

Original text of this message

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