What is the difference between Optimisation wizard and Column Population Jobs?

General
1

What is the difference between Optimisation wizard and Column Population Jobs?When optimisation wizard exposes the property then why do we need column population jobs

2

@TanyaS58

When you run the optimization wizard, Pega actually runs a column population job backend. In SQL terms its known as column population job but in Pega its call property optimization.

3

@SohamM95 oh so basically they are same?

4

@TanyaS58

More or less yes. You can get more info here.

5

Hi @TanyaS58 ,

The difference between the Optimization Wizard and Column Population Jobs in Pega is as follows:

Optimization Wizard: Used to expose properties by creating new columns in the database table, allowing for efficient querying and reporting.

Column Population Jobs : Used to populate the new columns with existing data from the BLOB, ensuring the new columns contain accurate data for use.

Why both are needed : The Optimization Wizard creates the new columns, and Column Population Jobs fill these columns with the existing data, making both steps necessary for effective property optimization.

Thanks,

Mohd Qizer Uddin