2 pts Question 7 The Human Resources Department would like to add a photo to the

Question

2 pts Question 7 The Human Resources Department would like to add a photo to the Salesperson table to identify each salesperson. In testing, adding a an image column to this table slows down all processing against the Salesperson table. What could be done to reduce the impact of adding the picture? O Vertically partition the Salesperson table. One partition would be the primary key and the image. The other partition would be the primary key plus all the other columns (except the image. O Create a function based index on the image column. O Horizontally partition the Salesperson table. O Create a bitmap index on the image column.

Explanation / Answer

7

create a bit map index on image column

8

create a bitmap index on the calculation price cost

9

increase frequency of check points

10

a

11

create surrogate primary key

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.