Optimization PGD has been optimized using the following techniques SQL Indexes SQL Aggregate Functions In Memory Tables Denormalized Search Table