You can translate the question and the replies:

Create a birmap indexes in a remote table

Hi, Is there a way to create a bitmap index in a remote table ? Pierre SANGUINETTI
user
13-02-2021 04:56:56 -0500

1 Answer

Hi, If I want to create indexes in a **[Remote table](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/remote_tables/remote_tables#remote-tables)**, I would navigate to the **Options** -> **Indexes** tab of the remote table base view and click on **[create index](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_derived_views/advanced_configuration_of_views/indexes_of_views#creating-an-index-in-the-underlying-database-of-a-remote-table-or-a-summary)** option. By doing this, I was able to create an index of type CLUSTER/ B-TREE/ HASH in the underlying database. For creating a bitmap index, you can create it directly in the underlying database which supports it. You can take a look at the **[Indexes of Views](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_derived_views/advanced_configuration_of_views/indexes_of_views#indexes-of-views)** section of Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
15-02-2021 06:26:37 -0500
You must sign in to add an answer. If you do not have an account, you can register here