Data Infrastructure Management Software Discussions

WFA INDEX in a custom dictionary

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,



Re: WFA INDEX in a custom dictionary



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 



If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

Cloud Volumes ONTAP
Review Banner
All Community Forums