If you are running a query or direct operation to the Aranda FIELD SERVICE AFLS tables, you should consider the following recommendations that allow database performance to be uncompromised in the operation:

• You should not manually modify the information stored in the databases, avoiding unexpected behavior in the application.
• Use replicas of the data for historical reporting.
• When building reports, avoid querying all fields in a table using the wildcard character (*)
• When building reports, avoid running SQL commands that query tables in their entirety, instead define WHERE clauses that allow you to get a tight number of rows.
• Don’t delete data from tables unless you’re clear about the implications. Deleting data may affect the operation of the software. This task may require approval from the audit area and/or the company’s management.
• Use the TRUNCATE statement when you need to delete all records from a large table, making the process more efficient since it does not generate entries in the transaction log