# Advanced Usage In this chapter, we'll look at the Data Definition Language (DDL) operations in my ORM system that allow us to effectively manage the structure of our databases by enabling the execution, generation, and application of SQL queries to make changes. Data indexing, which improves search performance and optimizes large data sets, will also be considered. Then there will be triggers that automate the execution of certain actions when events occur in the database, increasing the level of control and security. And at the end, there will be query caching, which reduces the load on the database and speeds up the execution of frequent queries, which positively affects the overall performance of the system. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://myroslavs-organization.gitbook.io/orm/advanced-usage.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.