I made the upgrade from Oracle Database 10g to 11g!
I made the upgrade from Oracle Database 10g to 11g!
I have a table with 10 million records.
The first implementation of the SQL statement SQL> SELECT COUNT (*) from myTable
is carried out for 8 minutes. The subsequent implementation takes only 15 sec.
What do I need to be amended to implement the first SQL statement took only 15 sec.
Regards!
Hine
I have a table with 10 million records.
The first implementation of the SQL statement SQL> SELECT COUNT (*) from myTable
is carried out for 8 minutes. The subsequent implementation takes only 15 sec.
What do I need to be amended to implement the first SQL statement took only 15 sec.
Regards!
Hine
0