Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> more on 'high cpu...'

more on 'high cpu...'

From: Joe Armstrong-Champ <joseph.armstrong-champ_at_tufts.edu>
Date: Mon, 02 Jul 2007 11:34:33 -0400
Message-ID: <46891B09.6000408@tufts.edu>


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 - 10:34:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US