Question
1
Replies
341
Views
ericsson
Posted: November 29, 2018
Last activity: December 5, 2018
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 ?
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.