The Data Dictionary Index is a new feature designed to significantly enhance the performance of IN filter queries (in the data dictionary). By caching distinct values for selected columns in separate index tables, this feature ensures faster and more efficient query processing.
Users can select up to 30 attribute fields from the list per table for indexing that they want use with the IN filter, allowing for tailored optimization based on their specific data needs. This approach reduces the load on primary tables and accelerates data retrieval, providing a smoother and more responsive user experience.
Key Features:
- Column Selection: Users can select up to 30 attribute fields from the list per table for indexing, customizing the optimization to fit their data usage patterns.
- Efficient Query Processing: The caching mechanism significantly speeds up IN filter queries by using pre-stored distinct values.
- Automated Maintenance: The system automatically updates the index tables with new distinct values as data changes, ensuring up-to-date query performance.
This enhancement will provide users with a more efficient way to handle complex queries, leading to improved application performance and a better overall user experience