Multiple choice technology databases

Which data fields should be indexed in a data warehouse?

    1. Data fields that reference numeric data should be indexed.
    1. Only data fields that change over time should be indexed.
    1. Data fields that are referenced by queries should be indexed.
    1. All data fields should be indexed.
    1. Data fields that reference text and large object data should be indexed.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In a data warehouse, indexing should be applied to columns and data fields that are frequently referenced by queries to speed up data retrieval performance. Indexing every field or only fields changing over time would be inefficient and impractical.

Keep practicing — related questions