Oracle and large tables
Posted: Thu 31 Jan 2013 10:25
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?
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?