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: index

Re: index

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Thu, 29 Jul 2004 11:41:55 -0400
Message-ID: <SS8Oc.684$KF.4485@tor-nn1.netcom.ca>


/*+FIRST_ROWS*/ will not help as you're doing a FTS anyway. You want ALL_ROWS. Start with checking that your sorting is done in memory (is SORT_AREA_SIZE parameter big enough?)

select a.name, value
from v$statname a, v$sysstat
where a.statistic# = v$sysstat.statistic# and a.name in ('sorts (disk)', 'sorts (memory)', 'sorts (rows)') /

-- 
Syltrem

OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"dead" <OVOIZBACI-vlasic_at_vodatel.net> a écrit dans le message de
news:ceb1n6$2i3$1_at_sunce.iskon.hr...

> question :
> I have Primary key(index) on field ABC1 in table TABLE1
> if I put sql command : Select * from TABLE1
> I have result in 1 sec but in 'natural' order, not order by ABC1
> If I put sql command with order : Select * from TABLE1 order by ABC1
> I need 150sec to have result
> It's sam if I put /*+FIRST_ROWS*/
> Does I need to change some parameters on database, index or in sql command
> or it is normal on table of 800.000 col.?
>
>
Received on Thu Jul 29 2004 - 10:41:55 CDT

Original text of this message

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