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: Help with query...

Re: Help with query...

From: Anna C. Dent <anacedent_at_hotmail.com>
Date: Sun, 02 May 2004 12:39:07 -0700
Message-ID: <w7clc.52360$Jy3.22139@fed1read03> 





Andrew Metcalfe wrote:


> The following query is taking 10 minutes...

> 

> 	

> 	SELECT  a.*, b.id, t.tree_id

> 	FROM tbla a, tblb b, node_tree t

> 	where a.B_ID=b.id

> 	and t.node_id = b.node_id

> 	and h.fk1_id = '1030'




Is FK1_ID really a string data type; which is what the single quote 
marks signify?


If it is numeric, then get rid of the single quote marks so the
CBO will use the index.
Received on Sun May 02 2004 - 14:39:07 CDT












Original text of this message













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