Re: index

From: David Fitzjarrell <fitzjarrell_at_cox.net>
Date: 29 Jul 2004 15:47:15 -0700
Message-ID: <9711ade0.0407291447.44ce7030@posting.google.com>

"dead" <OVOIZBACI-vlasic_at_vodatel.net> wrote in message 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.?

I did not complete my post as it should have been. The final act, after changing the sort_area_size, is to restart the database.

David Fitzjarrell Received on Thu Jul 29 2004 - 17:47:15 CDT