Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Can we use dataset value to refer in techincal rule

RG14
New Contributor
New Contributor

we have lot of conditions in technical rules, so we are planning to add values in dataset and then refer those values from dataset in technical rules. will it impact the performance.

5 REPLIES 5

Amar_Simha
Regular Contributor
Regular Contributor

@Amar_Simha will it cause any performance issue

Amar_Simha
Regular Contributor
Regular Contributor

We did not observe any issue far, but I will let forum experts advise on the same.

Yes you can use dataset. And performance issue is based on no. Of users and values in dataset which will need scanning time

a.email IS NOT NULL AND (substring_index(a.email,'@',-1) in (SELECT attribute1 from Dataset_Values where datasetname = 'dataset'))


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

PremMahadikar
All-Star
All-Star

Hi @RG14 ,

I don't see any performance issue either.

Sample code for reference:

  • a.userkey=998877 and a.customproperty22 in (select distinct dataset_values.attribute1 from dataset_values where dataset_values.datasetname = 'City' )

 

If this helps, please consider selecting Accept As Solution and hit Kudos