Cost-Based Optimizer

Meanwhile, in a space-time continuum unknown to Earth, jdennis_at_netcom.com wrote:

> I "EXPLAINED" the query and it shows
> a large table (12,000+ rows) being used as "driving" table against
> a small table (14 rows).

Check your SQL; Oracle parses from the bottom up, so put your most selective join condition last.

hth -

jh

--

---
 þ KWQ/2 1.2d NR þ 
                                                                                                                                                        
-- 
Jared Hecker                 |  
hecker_at_panix.com             |
76276,740_at_compuserve.com     |  
X.400 coming soon!           |