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.
A company"™s users are seeing slow performance when opening the Work Order Tracking application. After some investigatio
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
A company"™s users are seeing slow performance when opening the Work Order Tracking application. After some investigatio
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!