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