Data Infrastructure Management Software Discussions

WFA INDEX in a custom dictionary

LucianoCoelho
views-count 1109 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

Re: WFA INDEX in a custom dictionary

sinhaa
views-count 1110 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.

G2 Review Banner
All Community Forums
Public