Implement security and optimize performance

Create or modify duties, privileges, permissions, and roles

Enforce permissions policies

Implement Extensible Data Security (XDS) policies

Enforce Microsoft Entra ID authentication

Apply caching mechanisms for forms and tables

Implement the global cache and singleton

Create or modify temporary tables for optimization purposes

Assess when to use set-based queries and row-based queries

Modify queries to optimize performance

Modify variable scope to optimize performance

Analyze and optimize concurrency

Capture traces by using TraceParser and analyze traces

Optimize performance for data entities, data source queries, batch processes, and reports

Implement the Async and Sandbox frameworks

Create or modify indexes for tables and views