My problem is diferent than TOraclewwDataset

[mfdez]

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

it open in 2 or 3 seconds

but if the sql is

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 !!

 

[Marco Kalter]

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