topic Re: WFA INDEX in a custom dictionary in Active IQ Unified Manager Discussions

WFA INDEX in a custom dictionary

LucianoCoelho — Wed, 04 Jun 2025 22:42:18 GMT

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

Re: WFA INDEX in a custom dictionary

sinhaa — Wed, 25 Nov 2015 09:56:58 GMT

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