Re: HELP: Oracle running really slow.

Hi Dan,

did you try optimizer hints?
I have very good results with:

alter session set optimizer_goal = rule;  ... first_rows

Or use:

select /*+ rule */ Count(*)

   From jwl_rep, jwl_alignment
   Where jwl_rep.rep_id = jwl_alignment.rep_id;

select /*+ first_rows */ Count(*)

   From jwl_rep, jwl_alignment
   Where jwl_rep.rep_id = jwl_alignment.rep_id;

See: file:/816_DOCS/DOC/server.816/a76992/hints.htm in your generic help CD.

Good luck,

Toni

-- 
ZXR750H, 55 Mm. 
Q: How did the medical community come up with the term "PMS"?
A: "Mad Cow Disease" was already taken.
Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner