2 large databases - worth merging into 1?

I have 2 large databases that were shared before. I now have removed the sharing and have created a new database with all of the data except for the tables that were originally shared. Is it worth importing this data into the new database, or keeping them as separate entities that I can just scan through? We are talking around 60million records in each shared table, of which there are 2 tables.

Also, whilst I have an empty table, should I be adding indexes which weren't thought of when the database was originally constructed and now too large to add them?

Answers


I have decided to merge the databases. I took a good look at what indexes were missing and adding them whilst the table was empty. These indexes have improved the speed and efficiency of the large tables.


Need Your Help

How to create a drop-in replacement for an existing dll?

windows dll map replace export

Beyond creating a dll with all the same functions with the same interface and calling conventions, does the replacement dll need to exactly duplicate the export map including ordinal numbers of the

how to get database level roles into @preAuthorize method and <sec:authorise tag

spring-security

Actually i have roles in database like ROLE_USER,ROLE_MAKER,ROLE_CHECKER.now i am using method level restriction by mentioning @PreAutorize(hasRole('ROLE_USER','ROLE_MAKER'),