Users complain that it takes several seconds to get the result for DQL queries on dm_document searching for keywords. Your database administrator says that the disk I/O rate on the database machine is consistently high and no other change can be made to the database hardware. The database and Content Server run on separate hosts. How could you solve this problem on the Content Server?

Question

Accepted Answer

C. create a database index on the keywords column of the dm_sysobject_r table

Answer

A. add more or faster CPUs on the Content Server machine

Answer

B. create a selective database index against the dmr_content_s table

Answer

D. buy faster disks for storing the Documentum content

Users complain that it takes several seconds to get the result for DQL queries on dm_document searching for keywords. Your database administrator says that the disk I/O rate on the database machine…

Question

Options

How the community answered

Community Discussion