Re: What happened to speed?

This looks like you are using cost based optimizer, and the statistics in the dictionary are not in sync with the actual situation. Hence it is choosing the wrong driving table, or still performing full table scans and merge/hash joins where using indexes would have been more appropiate. There should be sites like www.jlcomp.demon.co.uk or http://www.ipass.net/~dsisk/oont
However, tuning is such a broad subject it will never be handled in full on a website.

Hth,

--
Sybrand Bakker, Oracle DBA
Ben Heuer <queerczarNOquSPAM_at_unforgettable.com.invalid> wrote in message news:0a0bc822.d370f90a_at_usw-ex0101-008.remarq.com...
> Hello all,
>
> I have two tables which I am joining inside my SQL and everything works
> like an express train when these tables have 3000 records each. Now
> when I have 34000 and 17000 records respectively, it is VERY slow
> (takes half a minute to even begin to return the resultset!)
>
> All the indices are in place!
>
> I would really be obliged if someone could tell me what I can do to
> increase the speed! Is there a site I can visit that tells me how to
> "tune" the database?
>
> Thanks a lot in advance!
> Ben
>
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Sat Dec 11 1999 - 23:06:21 CST