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.
Answer: A