Tag Info

Hot answers tagged

1

Having been on the receiving end of this multiple times from COTS applications, I would choose multiple databases almost every time. In this case, I would still choose multiple databases over any other, and here is why: !This is for the SQL Server related tag and is not transferrable in logic to other RDBMSs! Standards - each database is setup the same ...


1

Your question is too broad and opinion based for this forum. There are too many permutations and combinations. Start with the Oracle docco. Don't forget OS metrics - sysstat for Linux or see here for ideas about Windows (you didn't even mention your OS). Are you running an OLTP or an OLAP system? Different answers! Do you have a on-premise or cloud system? ...


1

can you add more information about the second table (not the one with 10 rows). can you tall a litel more about the Activity on this table, the second one, a.are we talking about table with X rows ? b. How match of DML activity (inser/update/delete) ? c. How many batch request ? 10x itzik paz



Only top voted, non community-wiki answers of a minimum length are eligible