Question

1
Replies
346
Views
 nikita sinha (nikitas1350)
ericsson

ericsson
IN
nikitas1350 Member since 2017 7 posts
ericsson
Posted: November 29, 2018
Last activity: December 5, 2018
Posted: 29 Nov 2018 0:10 EST
Last activity: 5 Dec 2018 4:40 EST
Closed

Best way to create segment

Is there any best way of creating segment in pega marketting ?

Currently on 7.3 version, we created segment in visualized mode and it took a long time around 1 hour above and finally segment run got failed. Our segment targets 1.3 million customer

So is there any other way to create and run segment successfully ?

Pega Marketing
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 2 years ago
Posted: 5 Dec 2018 4:40 EST
Manu Varghese (ManuV_GCS)
PEGA
Principal Software Solutions Engineer
Pegasystems Inc.
GB

Hi 

which mode are you using for segments, DDS or database. in Application settings ->Confiuguration settings -> "Use Decision Data Source" checked?.


I think the segments are created as "insert into <seg table> as select ... from <customer table> where ....", so ideally it purely depends on the criteria.


you could get the sql used to populate the segment table but enabling debug on PopulateSegmentTable activity and check the explain plan.