Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with query...
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