Primavera Data Warehouse has default schema hints that are added based on sample data. The hints aim to improve performance across all data sets. To further improve performance, you can add non-default schema hints to Primavera Data Warehouse. You should investigate adding non-default hints if you see bottlenecks in query performance or when you run the STARETL process on your data set.