Suppose you are a DBA of a 5,000-person organization. Your boss wants to know the advantages of using a partitioned table and the ways it will affect performance of the server, specifically during peak hours. Decide whether or not a vertical partitioned table is more effective than a horizontal table. Justify your response.
Advantages of using partitioned table: improving performance manageability availability control cost There are two factor... View the full answer