--- title: Understand Indexes overview description: From a Model Object in the Dataflow Modeling overview page, you can access the Indexes overview of the Model Object by clicking on its Context menu and choosing the Manage Indexes option: --- [Skip to content](https://knowledge.bigenius-x.com/understand-indexes-overview#main-content) [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal?hsLang=en) [![TRI\_Logo\_biGENIUS\_2020\_RGB\_s](https://knowledge.bigenius-x.com/hs-fs/hubfs/Marketing/TRI_Logo_biGENIUS_2020_RGB_s.png?width=150&height=42&name=TRI_Logo_biGENIUS_2020_RGB_s.png)](https://www.bigenius-x.com/) Open main navigation Close main navigation - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new) - [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal) How can we help you? - There are no suggestions because the search field is empty. 1. [biGENIUS-X Knowledge Base](https://knowledge.bigenius-x.com/?hsLang=en) 2. [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en) 3. [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-indexes) # Understand Indexes overview **Applies to** Platform: Microsoft SQL Server · Oracle From a **Model Object** in the [**Dataflow Modeling overview**](https://knowledge.bigenius-x.com/understand-modeling-overview?hsLang=en) page, you can access the **Indexes overview** of the **Model Object** by clicking on its Context menu and choosing the Manage Indexes option: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-04-2026-01-05-41-2021-PM.png?width=388&height=467&name=image-png-Mar-04-2026-01-05-41-2021-PM.png) Only Microsoft SQL Server and Oracle projects offer Manage Indexes. On other platforms, for example Snowflake, the menu of a model object has no such option. It is made up of several areas: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-04-2026-01-06-47-9383-PM.png?width=670&height=203&name=image-png-Mar-04-2026-01-06-47-9383-PM.png) Here, you manage the custom indexes of each target object. The generator adds them to the default indexes of the Generator Configuration, unless you deactivate the default indexes. All the available functions in the table are described here: [Understand the available functions in the tables](https://knowledge.bigenius-x.com/understand-the-available-functions-in-the-tables?hsLang=en). 1. The [**Indexes overview** left menu](https://knowledge.bigenius-x.com/understand-indexes-overview#left-menu) 2. The [**Indexes overview** content](https://knowledge.bigenius-x.com/understand-indexes-overview#content) ### Left menu In the **Indexes overview** left menu, you can open the Custom Indexes list for each Target Object of the Model Object. Here, there are 5 Target Objects (Tables) for the Satellite Model Object Type: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-04-2026-01-11-47-9224-PM.png?width=300&height=217&name=image-png-Mar-04-2026-01-11-47-9224-PM.png) More information about the Target Objects is available here: [Understand the Generator target objects](https://knowledge.bigenius-x.com/understand-the-generator-target-objects?hsLang=en). ### Content In the **Indexes overview** content, you can: - Activate or deactivate the default indexes provided by the Generator Configuration with the toggle above the list. **Default and Custom Indexes** creates both. Choosing the toggle opens the dialog **Only Custom Indexes**; confirm it with **APPLY** or close it with **CANCEL**: - Default indexes are deactivated (only Custom ones will be applied): ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-04-2026-01-54-21-8485-PM.png?width=213&height=44&name=image-png-Mar-04-2026-01-54-21-8485-PM.png) - Default indexes are activated and will be applied in addition to the Custom ones: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-04-2026-01-54-33-7773-PM.png?width=264&height=48&name=image-png-Mar-04-2026-01-54-33-7773-PM.png) - [Add an Index](https://knowledge.bigenius-x.com/add-an-index?hsLang=en) for a Target Object ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-04-2026-01-16-09-4390-PM.png?width=140&height=46&name=image-png-Mar-04-2026-01-16-09-4390-PM.png) - [Edit an Index](https://knowledge.bigenius-x.com/edit-an-index?hsLang=en) ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-04-2026-01-17-09-6970-PM.png?width=670&height=116&name=image-png-Mar-04-2026-01-17-09-6970-PM.png) - [Delete an Index](https://knowledge.bigenius-x.com/delete-an-index?hsLang=en) ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-04-2026-01-17-28-0870-PM.png?width=670&height=116&name=image-png-Mar-04-2026-01-17-28-0870-PM.png)   - [Getting started](https://knowledge.bigenius-x.com/getting-started?hsLang=en#main-content) - [Guidelines](https://knowledge.bigenius-x.com/getting-started?hsLang=en#guidelines) - [Start working](https://knowledge.bigenius-x.com/getting-started?hsLang=en#start-working) - [Account](https://knowledge.bigenius-x.com/getting-started?hsLang=en#account) - [General overview](https://knowledge.bigenius-x.com/general-overview?hsLang=en) - [Artificial Intelligence](https://knowledge.bigenius-x.com/artificial-intelligence?hsLang=en) - [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en#main-content) - [Administration](https://knowledge.bigenius-x.com/application-modules?hsLang=en#administration) - [Solutions](https://knowledge.bigenius-x.com/application-modules?hsLang=en#solutions) - [Global Features](https://knowledge.bigenius-x.com/application-modules?hsLang=en#global-features) - [Projects](https://knowledge.bigenius-x.com/application-modules?hsLang=en#projects) - [Branches](https://knowledge.bigenius-x.com/application-modules?hsLang=en#branches) - [Data Connections](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-connections) - [Dataflow Modeling - Overview](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-overview) - [Dataflow Modeling - Wizard Steps](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-wizard-steps) - [Dataflow Modeling - Terms](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-terms) - [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping) - [Dataflow Modeling - Relationships](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-relationships) - [Dataflow Modeling - Data Quality](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-data-quality) - [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-indexes) - [Relationship Modeling](https://knowledge.bigenius-x.com/application-modules?hsLang=en#relationship-modeling) - [Generate Artifacts](https://knowledge.bigenius-x.com/application-modules?hsLang=en#generate-artifacts) - [Project Settings](https://knowledge.bigenius-x.com/application-modules?hsLang=en#project-settings) - [Data Marketplace](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-marketplace) - [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en#main-content) - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks) - [Databricks dbt](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks-dbt) - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse) - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse) - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server) - [Oracle](https://knowledge.bigenius-x.com/generators?hsLang=en#oracle) - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake) - [Snowflake dbt](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake-dbt) - [Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#artifacts) - [Replace Placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders) - [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment) - [Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment) - [Deployment with an Azure DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azure-devops-pipeline) - [Delta Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#delta-deployment) - [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment) - [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control) - [Load data with Apache Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow) - [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type) - [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties) - [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms) - [Discovery application](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#main-content) - [Discovery configurations](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#discovery-configurations) - [Best practices](https://knowledge.bigenius-x.com/best-practices?hsLang=en#main-content) - [Modeling Approaches](https://knowledge.bigenius-x.com/best-practices?hsLang=en#modeling-approaches) - [Use Cases](https://knowledge.bigenius-x.com/best-practices?hsLang=en#use-cases) - [Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules) - [Data Quality Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#data-quality-rules) - [FAQs](https://knowledge.bigenius-x.com/faqs?hsLang=en) - [Product Release Notes](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#main-content) - [SaaS Application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#saas-application) - [Discovery application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#discovery-application) - [Generators](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#generators) - [Legal Documents](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#main-content) - [Current legal docs](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#current-legal-docs) - [Software Product and Limits](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#software-product-and-limits) - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) - [Customer Portal](https://knowledge.bigenius-x.com/customer-portal) - [Sign in](https://knowledge.bigenius-x.com/_hcms/mem/login) [![biGENIUS logo](https://knowledge.bigenius-x.com/hubfs/TRI_Logo_biGENIUS_2020_RGB-1.svg "biGENIUS logo")](https://www.bigenius-x.com) All rights reserved © 2025, biGENIUS AG