Category: SQL

PSQuery is a great tool for PeopleSoft ad hoc reporting. But it does have a challenge when it comes to working with Dates.
Use MetaSQL to manipulate dates in PSQuery

Use Materialized Views to improve poor performance of complex SQL Views