Re: Help with a Left Join
Posted by:
Nick Roper
Date: August 15, 2004 03:01AM
Brandon,
I see that you are quoting the '0' and '4' in your condition. If the column types are numeric then you don't need to use quotes. It might also be worth using the != operator for non-equality. This use of quotes may impact on the query optimisation as the index will be built on a numeric data type, but you're actually using a string as the criteria - which might cause the optimiser to ignore the indices. In addition the strings will have to be cast to numerics before doing the comparison.
In situations like this is is useful to use EXPLAIN... in front of the query to see how the optimiser is executying the query and what indices it is using.
Let us know how you get on.
Nick
--
Nick Roper
Subject
Written By
Posted
Re: Help with a Left Join
August 15, 2004 03:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.