Exit C2010-530 IBM Maximo Asset Management V7.6 Infrastructure and Implementation
Question 4 of 5
0% complete
Q4 Single choice

A company's users are seeing slow performance when opening the Work Order Tracking application. After some investigation it is determined that the default query is doing a full table scan.

How can this be prevented?

  • A

    Verify default table indexes exist.

  • B

    Verify columns in the SQL statement WHERE clause are not indexed.

  • C

    Verify no leading wildcard character in the SQL statement WHERE clause.

  • D

    Verify the Maximo user executing the SQL statement has query rights to the table.

Previous Next