Database with alot of records
I have a database with 200+ million reconds in one table.
Is this manageable? Right now it is running very slow, but the server needs to be upgraded.
The table has 4 fields.
3 x Int
and 1 x varchar(100) Primary index
Do you think I can expect fast results on SQL's that search the varchar field and order by an Int field?
Subject
Written By
Posted
Database with alot of records
March 03, 2015 04:11AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.