What process should a DBA use to ensure that system data processing is faster and more efficient?

• A. Data normalization
• B. Index creation
• C. Data migration
• D. Query optimization

Answer: (B)

Index creation is a crucial process that a DBA can utilize to enhance the speed and efficiency of data processing within a database. When an index is created, it allows the database management system to find and retrieve data more quickly, much like an index in a book helps a reader locate information without having to read every page.

Indexes work by maintaining a data structure that allows for rapid lookups, making it easier to perform searches, sorts, and even joins. This is especially significant in large databases where searching for specific records can otherwise be time-consuming. With proper indexing, the system can reduce the amount of data that needs to be scanned, thereby improving overall query performance.

Applying indexing wisely is essential, as excessive or poorly planned indexes can lead to increased storage requirements and slower performance during data modification operations (like inserts, updates, or deletes). However, when balanced appropriately, index creation significantly contributes to faster data retrieval times and overall system efficiency.

While normalization, data migration, and query optimization are valuable processes that serve different purposes—such as structuring data efficiently, transferring data between systems, or refining query processes—index creation specifically targets speed and efficiency in data retrieval, validating its selection as the effective process in this context.