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.