[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@xxxxxxxxx>
Organization: Tufts University
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>

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

Other related posts: