• Database Performance Best Practices

    • Revision #6
    • on
    The document provides a list of best practices applicable to database query performance. See also Introduction to Query Optimization and SAIL Performance Tuning . ...
  • An Introduction to Query Optimization

    • Revision #6
    • on
    This play provides an introduction to database query optimization. As a general recommendation, design your applications using Appian Records with Data Sync enabled...
  • GDPR Design Guide

    • Revision #8
    • on
    This guide provides Appian designers and administrators with the essential technical information they need to consider with respect to personal information managed by...
  • SQL Scripts that can be Rerun

    • Revision #4
    • on
    This guide deals with writing database scripts which can be rerun (‘rerunnable’). Creating rerunnable scripts makes deployments easier and avoids any unwanted behavior...
  • Working with Advanced CDT Structures

    • Revision #4
    • on
    Many-to-Many Relationships A many-to-many relationship occurs when one or more rows in a table are associated with one or more rows in another table. This is a conceptual...