I have the folowing problem:

I have a table named PRUEBA with two columns
and 15,000 rows:
cod number(9)
des varchar2(30)

two indexes
primary cod
secondary des

when i open the table with the sql
<select * from PRUEBA>
it open in 2 or 3 seconds

but if the sql is
<select * from PRUEBA order by des>
it open in Oracle Server.8 30 seconds
it open in Personal.8 in 50 seconds more or less.

Someone knows what happend?

Please help me!!

My project is stopped since 19/08/2000.

Thanks and Excuse me for my English !!

Perhaps you can use the explain plan utility or the tkprof utility and SQLTrace to find out what is going on during these 30 seconds? It seems to me that the Oracle Server has decided to do a full table scan and an internal sort, instead of using the index. If so, perhaps the statistics for this table needs to be analyzed:

analyze table prueba compute statistics;


------------------
Marco Kalter
Allround Automations