I forgot
Regarding your index : if you`re only pulling data (columns) from the index
key in your select, you`ll get a difference in the time it takes to complete
your request, becvause Oracle will only read the index, not the table.
In your case it ignores the index; reading it would just take longer
--
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:cear88$ti7$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:45:42 CDT
