[Fwd: more on 'high cpu...']

Let me rephrase. I know that distincts can cause a lot of sorting which in turn can cause high cpu. I guess I'm wondering if there is any work around for this? I'm searching for problems on distincts on metalink but other than old bugs I'm not coming up with much.

• Original Message -------- Subject: more on 'high cpu...' Date: Mon, 02 Jul 2007 11:34:33 -0400 From: Joe Armstrong-Champ <joseph.armstrong-champ_at_tufts.edu> Organization: Tufts University To: ORACLE-L <oracle-l_at_freelists.org>

I'm still doing the traces but in the meantime I thought I'd ask a follow up question. The query is selecting from a view. The view returns hundreds of rows relatively quickly. The query itself is selecting DISTINCT rows from the view. When I take out the distinct it returns almost instantaneously. With the distinct in it takes 40 - 50 secs. Does this ring a bell with anyone?

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jul 02 2007 - 11:27:03 CDT