Question1Replies341Views×Close popovernikita sinha (nikitas1350) ericsson ericsson IN View ProfileSend Message nikitas1350 Member since 2017 7 posts ericsson Posted: November 29, 2018Last activity: December 5, 2018Posted: 29 Nov 2018 0:10 ESTLast activity: 5 Dec 2018 4:40 EST Closed Best way to create segmentIs 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 customerSo is there any other way to create and run segment successfully ? Pega Marketing ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! 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 agoPosted: 5 Dec 2018 4:40 EST×Close popoverManu Varghese (ManuV_GCS) PEGA Principal Software Solutions Engineer PEG GB View ProfileSend MessageManuV_GCS PEGA replied to nikitas1350Hi 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.