Exam DISC-DA Practice Question 17
Study guide: Exam DISC-DA
A claim table of 3,000,000 rows is loaded nightly and queried all day. Most queries join it to the policy table on policy_id; some filter on claim_status, which takes three values (open, closed, reopened). The table already has its primary key on claim_id. Which additional index is most likely to repay its cost?
- A) An index on
claim_status, since many queries filter on it - B) An index on every column, so that any query can use one
- C) A secondary index on
policy_id, the column most joins use - D) A second primary index, built on
policy_id
Answer this question and see the worked solution