# eXtremeSQL Implementation Details

> The eXtremeSQL syntax and detailed information for the following topics are provided in separate pages. Please use the links below to view the individual topics:

> Changing the schema | Alter table and other methods for modifying the database schema
> Autoid References | Using `autoid` fields for highly efficient object references
> User_Defined_Functions | Implementing eXtremeSQL User-Defined Functions (UDF)
> Dynamic Memory Allocation | Managing memory allocation for query execution
> Full Outer Joins | Implementing `right outer` and `full outer` joins with eXtremeSQL
> Asof Joins | Joining tables according to `date/time` column ranges
> Numeric Fields | Considerations for fields if type `numeric`
> DateTime FIelds | Managing `date`, `time` and `datetime` fields
> SQL Statements | SQL statement string length limitations
> Bitwise Operations | Using `AND,OR` and `NOT` to perform bitwise operations
> Views | Implementing read-only views
> Virtual Tables | Using temporary "virtual" tables for data of a non-permanent nature
> RSQL and Security Measures | Remote SQL application implementation, password protection and OpenSSL
> Two-Phase Commit | Using the eXtremeSQL Two-Phase Commit