When the performance on one table is bad, it can either be an indexing problem, or a storage problem. If an indexing problem, add the required index, or remove the superfluous indeces. If a storage problem, figure out how and where to store the table. This latter is specific to the DBMS in use. However, such things often involve a partitioned key, in which the DBMS does what you’re talking about, without programmer or program involvement. Also, it allows you to change schemes repeatedly, without changing any code. Back out the related code changes now.
Sheldon Linker (email@example.com)
Linker Systems, Inc. (www.linkersystems.com)