The transition to NetApp MS Azure AD B2C is complete. If you missed the pre-registration, you will be invited to reigister at next log in.
Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

WFA INDEX in a custom dictionary

LucianoCoelho

Hi All,

 

I have created a custom dictionary for a Datasource and a full table scan is killing response time for a complex queries. I'm pretty sure that an index for some columns would solve the problem. Beside the primary key, is it possible to create index for a specific columns in a dictionary?

 

Best regards,

Luciano

1 REPLY 1

sinhaa

Luciano,

 

There is no way provided in WFA as of WFA3.1 to create index on WFA tables or their columns. The wfa DB user 'wfa' doesn't have the permission to do it on any other table except on scheme 'playground'. So if you are using 'playground' scheme then you can execute queries CREATE INDEX 

 

sinhaa

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.
Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public