Active IQ Unified Manager Discussions

WFA INDEX in a custom dictionary

LucianoCoelho
2,304 Views

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
2,221 Views

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.
Public