|
[oracle-l]
||
[Date Prev]
[07-2007 Date Index]
[Date Next]
||
[Thread Prev]
[07-2007 Thread Index]
[Thread Next]
more on 'high cpu...'
- From: Joe Armstrong-Champ <joseph.armstrong-champ@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 02 Jul 2007 11:34:33 -0400
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
|
|
