Hi.
I have a Perl DBI application connected to Oracle database. In this database there is
a table called "const_db" which includes about 80 fields. After the creation of this
table, everything is working fine, but after I load 40,000 records using SQL*Loader,
this application starts working extremely slow. The parts of this application which
have to call for a query "select * from const_db where id=X" are working so slow, that
the server deletes the process before it ends. The most unclear thing is that even if
I delete those 40,000 records, the speed remains very slow.
Please help me.
Thank you very much,
Konstantin.
