Oracle and large tables

[halley73to]

Hi,
i've a simple select on two tables: one with 600000 records and other with 7000000. Two tables don't have foreign key.

The query syntax is simple

select field1,
field2,
...,
fieldn
from table1,
table2
where table1.key = table2.key and
table1.field1 = parameter

It take 1 minute for extract 15 rows.

If i add another criteria like rownum <= 1000 it take 2 or 3 second for the same 15 rows.

What it can be?

[AlexP]

Hello,

Please test the query execution speed with the Oracle standard utility - SQL Plus - and if the results are different from the results of query execution in our components, contact us again.