Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> more on 'high cpu...'
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-lReceived on Mon Jul 02 2007 - 10:34:33 CDT
![]() |
![]() |