If users access only certain fields in a table, how can you improve performance?
A) by splitting the table into two or more tables and removing the primary key
B) by combining the table with another table that performs better
C) by splitting the table into two or more tables that each has the same primary key as the original
D) by adding indexes to each column and deleting the primary and alternate keys

Question

Quizplus · Accepted Answer

By splitting the table into two or more tables that each have the same primary key as the original, you can reduce the amount of data that needs to be accessed, thereby improving performance. This is sometimes referred to as horizontal partitioning, and is commonly used in situations where certain fields are accessed more frequently than others. By splitting the table and creating separate tables for the frequently accessed fields, you can optimize database performance and improve query response times.

If Users Access Only Certain Fields in a Table, How