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

Home -> Community -> Usenet -> c.d.o.server -> Re: Temp tablespace Initial extent question

Re: Temp tablespace Initial extent question

From: polu <wlrdexplorer_at_hotmail.com>
Date: Sun, 2 Dec 2001 17:59:18 -0500
Message-ID: <xlyO7.47373$S93.1397655@e3500-atl2.usenetserver.com>


You may want to check first if an you have full table scans. I you should look for a proper index to improve performance.

 >When I analyze the
> performance of these queries, I'm finding that oracle is spending 99%
> of it's time, just sorting the data.
>
>
Received on Sun Dec 02 2001 - 16:59:18 CST

Original text of this message

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